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. You can activate a cell by Clicking the cell Pressing the Tab key All of the above Pressing an arrow key2. Can we view gridline and heading in print preview ? No Yes3. To close MS Word which of the following method can we use Click on File tab button, then exit Click on Close button Click on Close button Click on view4. Which is used to perform what if analysis? Data Table All of these Scenario Manager Goal seek5. Can we use formula bar to edit formula ? No Yes6. Which shortcut key is used to comment to cell Shift + F2 Ctrl + F2 F3 F27. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Across Merge & Center Unmerge ell Merge Cell8. which shortcuty key is used to edit a cell ? F4 F2 Ctrl + 7 F99. Excel displays the current cell address in the ________ Status Bar Formula bar Name Box Title Bar10. Which Chart can be created in Excel? All of the these Area Line pie11. Which shortcut key is used to comment to cell Shift + F2 F3 Ctrl + F2 F212. The value of cell is displayed in View Formula bar Review Name box13. ____________ is shortcut to find and replace in ms excel. Shift + F Ctrl + F Ctrl + H Shift + H14. Comments put in cells are called Web Tip Soft Tip Smart Tip Cell Tip15. Excel is a program that is used to prepare a Database Text document Spreadsheet Slide presentation16. Which area in an Excel window allows entering values and formulas? Menu Bar Standard Tool Bar Formula Bar Title Bar17. Microsoft Excel is a powerful ________ Word processing package Communication S/W Package DBMS package Spreadsheet package18. ____________ Option is used to copy formatting from one cell to other cell . Format Painter Painter Format Cleaner Format19. To activate Microsoft excel through run command, the keyword is Excel Winexcel Msexcel microsoftexcel20. To activate Microsoft excel through run command, the keyword is Excel Msexcel Winexcel microsoftexcel21. 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 cell22. Which area in an Excel window allows entering values and formulas? Formula Bar Standard Tool Bar Menu Bar Title Bar23. The first cell in excel worksheet is _______ B1 A1 AA AB24. Can we view gridline and heading in print preview ? No Yes25. Comments put in cells are called Web Tip Cell Tip Smart Tip Soft Tip26. Excel displays the current cell address in the ________ Title Bar Formula bar Status Bar Name Box27. The value of cell is displayed in Review Name box View Formula bar28. Which term is used to join the selected cells in to one cell? Clear formatting Wrap text wrap Merge & Center29. To close MS Word which of the following method can we use Click on Close button Click on view Click on Close button Click on File tab button, then exit30. ____________ Option is used to copy formatting from one cell to other cell . Painter Format Format Cleaner Format Painter31. An Excel Workbook is a collection of ________ Charts Workbooks Worksheets Worksheets and Charts32. You can activate a cell by Clicking the cell Pressing an arrow key All of the above Pressing the Tab key33. Which of the following methods are used to edit cell Formula tab F1 Name box F234. A formula in Excel always begins with an ____ Sign Plus Equal Minus Multiply35. Can we use formula bar to edit formula ? Yes No36. MS-EXCEL is based on ________ WINDOWS OS/2 UNIX DOS37. Excel is a program that is used to prepare a Slide presentation Text document Spreadsheet Database38. which shortcuty key is used to edit a cell ? F9 F2 F4 Ctrl + 739. Which of the following is not the correct method of editing the cell content? Double click the cell Press the Alt key Click the formula bar Press the F2 key40. What is the shortcut key to replace a data with another in sheet? Ctrl + H Ctrl + F Ctrl + R Ctrl + Shift + R41. A ________ is a grid with labeled columns and rows. Worksheet Toolbar Clipboard Dialog box42. How many worksheets can we added in a workbook? 257 256 105 25543. What is extension of excel 2013 ? xlsx xlsm xlx xlxs.44. MS-EXCEL is based on ________ DOS UNIX WINDOWS OS/245. Which key do you press to check spelling? F4 F12 F6 F746. Which is used to perform what if analysis? All of these Goal seek Scenario Manager Data Table47. The first cell in excel worksheet is _______ A1 AB AA B148. All of the above Today () Now () Date () Time ()49. Which of the following methods are used to edit cell F1 Name box F2 Formula tab50. Which term is used to join the selected cells in to one cell? Wrap text Merge & Center wrap Clear formatting51. Which Chart can be created in Excel? Area pie All of the these Line52. What is the shortcut key to replace a data with another in sheet? Ctrl + H Ctrl + F Ctrl + Shift + R Ctrl + R53. Microsoft Excel is a powerful ________ Word processing package Communication S/W Package Spreadsheet package DBMS package54. An Excel Workbook is a collection of ________ Charts Worksheets and Charts Workbooks Worksheets55. ____________ is shortcut to find and replace in ms excel. Ctrl + H Shift + F Shift + H Ctrl + F56. A formula in Excel always begins with an ____ Sign Minus Equal Multiply Plus 57. Can we use table in excel to create filter ? Yes No58. Which of the following is not a term of MS-Excel? Columns Cells Document Rows59. All of the above Today () Time () Date () Now ()60. A ________ is a grid with labeled columns and rows. Dialog box Toolbar Clipboard Worksheet61. What is extension of excel 2013 ? xlxs. xlsx xlsm xlx62. Which option is used to join the selected cells into single cell and center the content of cell ? Merge & Center Merge Across Merge Cell Unmerge ell63. Which key do you press to check spelling? F12 F6 F7 F464. Which of the following is not a term of MS-Excel? Columns Cells Document Rows65. How many worksheets can we added in a workbook? 257 255 105 25666. Which of the following methods cannot be used to enter data in a cell Pressing the Esc key Clicking on the formula bar Pressing an arrow key Pressing the Tab key67. Which of the following methods cannot be used to enter data in a cell Pressing an arrow key Pressing the Esc key Clicking on the formula bar Pressing the Tab key68. Can we use table in excel to create filter ? Yes No Loading …Question 1 of 68