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. ____________ Option is used to copy formatting from one cell to other cell . Format Painter Format Cleaner Format Painter2. Which shortcut key is used to comment to cell F2 F3 Shift + F2 Ctrl + F23. 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 exit4. Can we use table in excel to create filter ? Yes No5. Which is used to perform what if analysis? All of these Data Table Goal seek Scenario Manager6. Which area in an Excel window allows entering values and formulas? Standard Tool Bar Menu Bar Formula Bar Title Bar7. Which term is used to join the selected cells in to one cell? wrap Clear formatting Wrap text Merge & Center8. Microsoft Excel is a powerful ________ Communication S/W Package Spreadsheet package Word processing package DBMS package9. Excel displays the current cell address in the ________ Formula bar Status Bar Title Bar Name Box10. What is the shortcut key to replace a data with another in sheet? Ctrl + R Ctrl + H Ctrl + F Ctrl + Shift + R11. All of the above Date () Time () Today () Now ()12. Which key do you press to check spelling? F6 F7 F4 F1213. 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 key14. Which key do you press to check spelling? F6 F7 F12 F415. ____________ is shortcut to find and replace in ms excel. Ctrl + H Shift + H Ctrl + F Shift + F16. Which of the following methods are used to edit cell F2 Formula tab F1 Name box17. The value of cell is displayed in Formula bar View Review Name box18. You can activate a cell by All of the above Pressing an arrow key Clicking the cell Pressing the Tab key19. 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 cell20. What is extension of excel 2013 ? xlxs. xlsx xlsm xlx21. Excel is a program that is used to prepare a Spreadsheet Slide presentation Database Text document22. Which Chart can be created in Excel? All of the these pie Line Area23. Can we view gridline and heading in print preview ? No Yes24. Which of the following is not a term of MS-Excel? Columns Cells Rows Document25. Comments put in cells are called Smart Tip Web Tip Soft Tip Cell Tip26. To activate Microsoft excel through run command, the keyword is Msexcel Winexcel Excel microsoftexcel27. What is extension of excel 2013 ? xlxs. xlsx xlsm xlx28. Can we use formula bar to edit formula ? No Yes29. How many worksheets can we added in a workbook? 257 105 256 25530. Can we use formula bar to edit formula ? No Yes31. Excel is a program that is used to prepare a Text document Slide presentation Spreadsheet Database32. Can we view gridline and heading in print preview ? Yes No33. An Excel Workbook is a collection of ________ Charts Workbooks Worksheets and Charts Worksheets34. ____________ is shortcut to find and replace in ms excel. Ctrl + H Ctrl + F Shift + H Shift + F35. which shortcuty key is used to edit a cell ? Ctrl + 7 F2 F9 F436. Which area in an Excel window allows entering values and formulas? Formula Bar Menu Bar Standard Tool Bar Title Bar37. A formula in Excel always begins with an ____ Sign Multiply Minus Plus Equal 38. What is the shortcut key to replace a data with another in sheet? Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H39. Which term is used to join the selected cells in to one cell? Wrap text Clear formatting Merge & Center wrap40. You can activate a cell by Pressing the Tab key Pressing an arrow key Clicking the cell All of the above41. An Excel Workbook is a collection of ________ Workbooks Worksheets Charts Worksheets and Charts42. A formula in Excel always begins with an ____ Sign Equal Multiply Plus Minus43. Can we use table in excel to create filter ? No Yes44. Which shortcut key is used to comment to cell F3 F2 Ctrl + F2 Shift + F245. The first cell in excel worksheet is _______ AB A1 B1 AA46. Which of the following methods are used to edit cell Formula tab F2 Name box F147. A ________ is a grid with labeled columns and rows. Clipboard Worksheet Dialog box Toolbar48. How many worksheets can we added in a workbook? 257 256 105 25549. To activate Microsoft excel through run command, the keyword is Excel Msexcel Winexcel microsoftexcel50. Excel displays the current cell address in the ________ Status Bar Title Bar Name Box Formula bar51. which shortcuty key is used to edit a cell ? Ctrl + 7 F9 F2 F452. Which of the following is not the correct method of editing the cell content? Press the F2 key Click the formula bar Double click the cell Press the Alt key53. Which option is used to join the selected cells into single cell and center the content of cell ? Unmerge ell Merge Cell Merge & Center Merge Across54. Comments put in cells are called Soft Tip Cell Tip Web Tip Smart Tip55. MS-EXCEL is based on ________ OS/2 UNIX DOS WINDOWS56. MS-EXCEL is based on ________ UNIX DOS WINDOWS OS/257. Which of the following is not a term of MS-Excel? Document Columns Cells Rows58. A ________ is a grid with labeled columns and rows. Toolbar Worksheet Clipboard Dialog box59. Microsoft Excel is a powerful ________ Communication S/W Package DBMS package Word processing package Spreadsheet package60. Which Chart can be created in Excel? All of the these pie Area Line61. Which of the following methods cannot be used to enter data in a cell Clicking on the formula bar Pressing the Tab key Pressing the Esc key Pressing an arrow key62. Which option is used to join the selected cells into single cell and center the content of cell ? Merge & Center Merge Cell Merge Across Unmerge ell63. The first cell in excel worksheet is _______ AA B1 AB A164. All of the above Time () Date () Today () Now ()65. To close MS Word which of the following method can we use Click on Close button Click on File tab button, then exit Click on view Click on Close button66. ____________ Option is used to copy formatting from one cell to other cell . Painter Format Painter Format Format Cleaner67. Which is used to perform what if analysis? Goal seek Data Table Scenario Manager All of these68. The value of cell is displayed in View Review Name box Formula bar Loading …Question 1 of 68