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. 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 exit2. A ________ is a grid with labeled columns and rows. Toolbar Clipboard Worksheet Dialog box3. Can we view gridline and heading in print preview ? No Yes4. What is the shortcut key to replace a data with another in sheet? Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F5. Excel displays the current cell address in the ________ Formula bar Title Bar Status Bar Name Box6. An Excel Workbook is a collection of ________ Workbooks Charts Worksheets and Charts Worksheets7. Excel is a program that is used to prepare a Slide presentation Text document Database Spreadsheet8. All of the above Date () Now () Today () Time ()9. Which key do you press to check spelling? F4 F7 F12 F610. You can activate a cell by All of the above Pressing the Tab key Pressing an arrow key Clicking the cell11. The first cell in excel worksheet is _______ B1 AB AA A112. A formula in Excel always begins with an ____ Sign Multiply Equal Minus Plus 13. Which area in an Excel window allows entering values and formulas? Standard Tool Bar Title Bar Menu Bar Formula Bar14. Which of the following is not a term of MS-Excel? Cells Columns Document Rows15. Which area in an Excel window allows entering values and formulas? Formula Bar Menu Bar Standard Tool Bar Title Bar16. Can we use formula bar to edit formula ? No Yes17. Can we use table in excel to create filter ? Yes No18. MS-EXCEL is based on ________ WINDOWS DOS OS/2 UNIX19. Microsoft Excel is a powerful ________ Communication S/W Package Word processing package Spreadsheet package DBMS package20. To close MS Word which of the following method can we use Click on view Click on File tab button, then exit Click on Close button Click on Close button21. ____________ is shortcut to find and replace in ms excel. Shift + H Shift + F Ctrl + F Ctrl + H22. Comments put in cells are called Soft Tip Web Tip Smart Tip Cell Tip23. Which key do you press to check spelling? F12 F4 F7 F624. Which of the following methods cannot be used to enter data in a cell Pressing an arrow key Pressing the Tab key Clicking on the formula bar Pressing the Esc key25. ____________ Option is used to copy formatting from one cell to other cell . Format Cleaner Format Painter Format Painter26. Which option is used to join the selected cells into single cell and center the content of cell ? Merge & Center Unmerge ell Merge Cell Merge Across27. An Excel Workbook is a collection of ________ Worksheets Workbooks Charts Worksheets and Charts28. What is the shortcut key to replace a data with another in sheet? Ctrl + R Ctrl + F Ctrl + H Ctrl + Shift + R29. What is extension of excel 2013 ? xlx xlsm xlxs. xlsx30. How many worksheets can we added in a workbook? 257 255 105 25631. Microsoft Excel is a powerful ________ DBMS package Communication S/W Package Spreadsheet package Word processing package32. Which term is used to join the selected cells in to one cell? Wrap text Clear formatting Merge & Center wrap33. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Across Merge Cell Merge & Center Unmerge ell34. Can we use table in excel to create filter ? Yes No35. which shortcuty key is used to edit a cell ? Ctrl + 7 F9 F2 F436. The first cell in excel worksheet is _______ AB AA B1 A137. Which of the following methods are used to edit cell F1 Formula tab Name box F238. Which shortcut key is used to comment to cell F2 F3 Ctrl + F2 Shift + F239. Which shortcut key is used to comment to cell F2 F3 Ctrl + F2 Shift + F240. Can we use formula bar to edit formula ? No Yes41. Excel is a program that is used to prepare a Spreadsheet Text document Database Slide presentation42. All of the above Date () Today () Now () Time ()43. Which term is used to join the selected cells in to one cell? Wrap text Clear formatting Merge & Center wrap44. Which of the following is not the correct method of editing the cell content? Press the Alt key Click the formula bar Press the F2 key Double click the cell45. ____________ Option is used to copy formatting from one cell to other cell . Format Cleaner Format Painter Format Painter46. What is extension of excel 2013 ? xlxs. xlsm xlx xlsx47. The value of cell is displayed in Formula bar Name box Review View48. Which Chart can be created in Excel? Line Area pie All of the these49. Which of the following methods cannot be used to enter data in a cell Pressing the Esc key Clicking on the formula bar Pressing the Tab key Pressing an arrow key50. Which of the following methods are used to edit cell Name box F1 Formula tab F251. Can we view gridline and heading in print preview ? No Yes52. A formula in Excel always begins with an ____ Sign Plus Minus Equal Multiply53. How many worksheets can we added in a workbook? 257 255 256 10554. The value of cell is displayed in Name box Review View Formula bar55. Which is used to perform what if analysis? Data Table Goal seek Scenario Manager All of these56. Excel displays the current cell address in the ________ Status Bar Title Bar Name Box Formula bar57. which shortcuty key is used to edit a cell ? F2 F4 Ctrl + 7 F958. To activate Microsoft excel through run command, the keyword is microsoftexcel Excel Msexcel Winexcel59. To activate Microsoft excel through run command, the keyword is Excel Msexcel microsoftexcel Winexcel60. You can activate a cell by Pressing the Tab key All of the above Clicking the cell Pressing an arrow key61. Which Chart can be created in Excel? Area pie Line All of the these62. Comments put in cells are called Smart Tip Soft Tip Web Tip Cell Tip63. Which of the following is not a term of MS-Excel? Cells Columns Rows Document64. ____________ is shortcut to find and replace in ms excel. Shift + F Ctrl + H Ctrl + F Shift + H65. MS-EXCEL is based on ________ WINDOWS OS/2 UNIX DOS66. Which is used to perform what if analysis? Goal seek All of these Scenario Manager Data Table67. A ________ is a grid with labeled columns and rows. Clipboard Dialog box Toolbar Worksheet68. Which of the following is not the correct method of editing the cell content? Press the Alt key Press the F2 key Click the formula bar Double click the cell Loading …Question 1 of 68