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. Excel displays the current cell address in the ________ Title Bar Formula bar Status Bar Name Box2. The value of cell is displayed in View Review Formula bar Name box3. Which of the following is not a term of MS-Excel? Rows Cells Document Columns4. What is extension of excel 2013 ? xlsx xlx xlsm xlxs.5. A ________ is a grid with labeled columns and rows. Toolbar Clipboard Dialog box Worksheet6. ____________ Option is used to copy formatting from one cell to other cell . Format Painter Format Cleaner Format Painter7. All of the above Now () Today () Date () Time ()8. which shortcuty key is used to edit a cell ? F9 F2 Ctrl + 7 F49. Which area in an Excel window allows entering values and formulas? Formula Bar Standard Tool Bar Menu Bar Title Bar10. Which Chart can be created in Excel? Area Line All of the these pie11. Which Chart can be created in Excel? pie Line All of the these Area12. How many worksheets can we added in a workbook? 256 255 257 10513. Microsoft Excel is a powerful ________ Communication S/W Package Spreadsheet package Word processing package DBMS package14. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Cell Unmerge ell Merge & Center Merge Across15. Which of the following is not the correct method of editing the cell content? Click the formula bar Press the Alt key Press the F2 key Double click the cell16. An Excel Workbook is a collection of ________ Worksheets Worksheets and Charts Charts Workbooks17. Which term is used to join the selected cells in to one cell? Clear formatting Merge & Center Wrap text wrap18. Which area in an Excel window allows entering values and formulas? Standard Tool Bar Title Bar Formula Bar Menu Bar19. Microsoft Excel is a powerful ________ DBMS package Communication S/W Package Word processing package Spreadsheet package20. Can we use formula bar to edit formula ? Yes No21. The first cell in excel worksheet is _______ B1 AA AB A122. To close MS Word which of the following method can we use Click on Close button Click on Close button Click on File tab button, then exit Click on view23. Can we use table in excel to create filter ? No Yes24. MS-EXCEL is based on ________ OS/2 DOS UNIX WINDOWS25. Which of the following is not the correct method of editing the cell content? Press the F2 key Double click the cell Press the Alt key Click the formula bar26. A formula in Excel always begins with an ____ Sign Plus Multiply Equal Minus27. The value of cell is displayed in View Review Formula bar Name box28. Which shortcut key is used to comment to cell F3 F2 Shift + F2 Ctrl + F229. Which key do you press to check spelling? F7 F4 F12 F630. Which term is used to join the selected cells in to one cell? Merge & Center Wrap text Clear formatting wrap31. A formula in Excel always begins with an ____ Sign Minus Plus Equal Multiply32. How many worksheets can we added in a workbook? 255 257 105 25633. Which of the following methods cannot be used to enter data in a cell Clicking on the formula bar Pressing the Esc key Pressing an arrow key Pressing the Tab key34. Which of the following methods are used to edit cell F1 F2 Name box Formula tab35. A ________ is a grid with labeled columns and rows. Toolbar Clipboard Worksheet Dialog box36. To activate Microsoft excel through run command, the keyword is microsoftexcel Excel Msexcel Winexcel37. Can we use formula bar to edit formula ? No Yes38. Excel is a program that is used to prepare a Spreadsheet Database Slide presentation Text document39. An Excel Workbook is a collection of ________ Worksheets Workbooks Worksheets and Charts Charts40. All of the above Time () Today () Date () Now ()41. Can we view gridline and heading in print preview ? Yes No42. Can we use table in excel to create filter ? Yes No43. 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 exit44. You can activate a cell by Clicking the cell Pressing an arrow key Pressing the Tab key All of the above45. What is the shortcut key to replace a data with another in sheet? Ctrl + Shift + R Ctrl + H Ctrl + F Ctrl + R46. What is extension of excel 2013 ? xlxs. xlsm xlsx xlx47. ____________ is shortcut to find and replace in ms excel. Ctrl + H Ctrl + F Shift + F Shift + H48. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Cell Unmerge ell Merge & Center Merge Across49. Which is used to perform what if analysis? All of these Goal seek Scenario Manager Data Table50. Comments put in cells are called Web Tip Smart Tip Soft Tip Cell Tip51. Comments put in cells are called Smart Tip Soft Tip Cell Tip Web Tip52. The first cell in excel worksheet is _______ AB A1 B1 AA53. MS-EXCEL is based on ________ UNIX DOS WINDOWS OS/254. You can activate a cell by All of the above Clicking the cell Pressing an arrow key Pressing the Tab key55. Excel is a program that is used to prepare a Spreadsheet Slide presentation Text document Database56. Which shortcut key is used to comment to cell F2 Ctrl + F2 F3 Shift + F257. Which of the following is not a term of MS-Excel? Document Rows Columns Cells58. Which of the following methods cannot be used to enter data in a cell Clicking on the formula bar Pressing the Esc key Pressing an arrow key Pressing the Tab key59. Can we view gridline and heading in print preview ? No Yes60. ____________ Option is used to copy formatting from one cell to other cell . Painter Format Cleaner Format Format Painter61. What is the shortcut key to replace a data with another in sheet? Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H62. Which of the following methods are used to edit cell Formula tab F1 F2 Name box63. Which is used to perform what if analysis? Scenario Manager Data Table All of these Goal seek64. Which key do you press to check spelling? F4 F12 F7 F665. Excel displays the current cell address in the ________ Formula bar Status Bar Title Bar Name Box66. ____________ is shortcut to find and replace in ms excel. Ctrl + H Shift + F Ctrl + F Shift + H67. which shortcuty key is used to edit a cell ? F9 Ctrl + 7 F2 F468. To activate Microsoft excel through run command, the keyword is microsoftexcel Msexcel Excel Winexcel Loading …Question 1 of 68