MS Excel Practice Session 1Basic Instructions for MCQ OnlineThe examination will comprise of Objective type Multiple Choice Questions (MCQs)All questions are compulsory and each carries One mark.There will be NO NEGATIVE MARKING for the wrong answers.1. A formula in Excel always begins with an ____ Sign Plus Minus Equal Multiply2. Excel displays the current cell address in the ________ Status Bar Formula bar Name Box Title Bar3. The value of cell is displayed in Review Formula bar View Name box4. Which of the following methods cannot be used to enter data in a cell Pressing the Tab key Pressing the Esc key Clicking on the formula bar Pressing an arrow key5. Which Chart can be created in Excel? pie Line Area All of the these6. MS-EXCEL is based on ________ WINDOWS DOS OS/2 UNIX7. To activate Microsoft excel through run command, the keyword is Excel Winexcel Msexcel microsoftexcel8. What is the shortcut key to replace a data with another in sheet? Ctrl + H Ctrl + R Ctrl + F Ctrl + Shift + R9. All of the above Now () Date () Time () Today ()10. which shortcuty key is used to edit a cell ? Ctrl + 7 F2 F4 F911. Comments put in cells are called Soft Tip Smart Tip Cell Tip Web Tip12. ____________ Option is used to copy formatting from one cell to other cell . Format Cleaner Format Painter Format Painter13. The first cell in excel worksheet is _______ A1 AA AB B114. Which of the following is not the correct method of editing the cell content? Press the F2 key Click the formula bar Press the Alt key Double click the cell15. which shortcuty key is used to edit a cell ? F9 F2 Ctrl + 7 F416. The value of cell is displayed in Formula bar Name box View Review17. Which shortcut key is used to comment to cell F3 Shift + F2 F2 Ctrl + F218. What is the shortcut key to replace a data with another in sheet? Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F19. Which Chart can be created in Excel? pie All of the these Area Line20. Can we use formula bar to edit formula ? No Yes21. You can activate a cell by Pressing an arrow key All of the above Pressing the Tab key Clicking the cell22. Which term is used to join the selected cells in to one cell? Merge & Center Clear formatting wrap Wrap text23. ____________ is shortcut to find and replace in ms excel. Ctrl + H Ctrl + F Shift + H Shift + F24. To activate Microsoft excel through run command, the keyword is Msexcel Winexcel microsoftexcel Excel25. A ________ is a grid with labeled columns and rows. Worksheet Clipboard Dialog box Toolbar26. Excel is a program that is used to prepare a Database Slide presentation Spreadsheet Text document27. To close MS Word which of the following method can we use Click on view Click on Close button Click on Close button Click on File tab button, then exit28. Which of the following is not a term of MS-Excel? Columns Document Rows Cells29. Comments put in cells are called Smart Tip Web Tip Soft Tip Cell Tip30. Which shortcut key is used to comment to cell F2 Shift + F2 Ctrl + F2 F331. Which of the following methods are used to edit cell Formula tab F1 F2 Name box32. What is extension of excel 2013 ? xlxs. xlx xlsx xlsm33. Which area in an Excel window allows entering values and formulas? Standard Tool Bar Menu Bar Formula Bar Title Bar34. An Excel Workbook is a collection of ________ Worksheets and Charts Workbooks Worksheets Charts35. Can we view gridline and heading in print preview ? No Yes36. Which option is used to join the selected cells into single cell and center the content of cell ? Unmerge ell Merge & Center Merge Across Merge Cell37. Which of the following methods are used to edit cell F1 F2 Formula tab Name box38. Can we use formula bar to edit formula ? No Yes39. How many worksheets can we added in a workbook? 255 256 105 25740. ____________ is shortcut to find and replace in ms excel. Ctrl + F Ctrl + H Shift + H Shift + F41. Which of the following methods cannot be used to enter data in a cell Pressing the Tab key Pressing an arrow key Clicking on the formula bar Pressing the Esc key42. A formula in Excel always begins with an ____ Sign Equal Minus Multiply Plus 43. Which key do you press to check spelling? F12 F6 F4 F744. Can we use table in excel to create filter ? Yes No45. Which is used to perform what if analysis? All of these Data Table Goal seek Scenario Manager46. Can we view gridline and heading in print preview ? Yes No47. Can we use table in excel to create filter ? No Yes48. Which of the following is not a term of MS-Excel? Columns Rows Cells Document49. To close MS Word which of the following method can we use Click on Close button Click on Close button Click on view Click on File tab button, then exit50. An Excel Workbook is a collection of ________ Worksheets Charts Worksheets and Charts Workbooks51. A ________ is a grid with labeled columns and rows. Dialog box Worksheet Clipboard Toolbar52. Which of the following is not the correct method of editing the cell content? Click the formula bar Press the F2 key Double click the cell Press the Alt key53. Which area in an Excel window allows entering values and formulas? Title Bar Standard Tool Bar Menu Bar Formula Bar54. Excel displays the current cell address in the ________ Formula bar Status Bar Title Bar Name Box55. You can activate a cell by Pressing the Tab key All of the above Pressing an arrow key Clicking the cell56. Which term is used to join the selected cells in to one cell? Merge & Center Clear formatting wrap Wrap text57. Microsoft Excel is a powerful ________ DBMS package Communication S/W Package Word processing package Spreadsheet package58. What is extension of excel 2013 ? xlx xlxs. xlsm xlsx59. Microsoft Excel is a powerful ________ Spreadsheet package Communication S/W Package Word processing package DBMS package60. MS-EXCEL is based on ________ UNIX WINDOWS OS/2 DOS61. All of the above Time () Today () Date () Now ()62. ____________ Option is used to copy formatting from one cell to other cell . Format Cleaner Painter Format Painter Format63. Which is used to perform what if analysis? Data Table Scenario Manager All of these Goal seek64. The first cell in excel worksheet is _______ B1 AA AB A165. Excel is a program that is used to prepare a Slide presentation Text document Spreadsheet Database66. Which key do you press to check spelling? F4 F6 F7 F1267. How many worksheets can we added in a workbook? 256 255 257 10568. Which option is used to join the selected cells into single cell and center the content of cell ? Unmerge ell Merge & Center Merge Across Merge Cell Loading …Question 1 of 68