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 view Click on File tab button, then exit Click on Close button2. 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 key3. Can we use table in excel to create filter ? No Yes4. Which key do you press to check spelling? F7 F6 F12 F45. Which of the following methods are used to edit cell F1 F2 Formula tab Name box6. The first cell in excel worksheet is _______ A1 AA AB B17. To activate Microsoft excel through run command, the keyword is Excel Msexcel microsoftexcel Winexcel8. What is the shortcut key to replace a data with another in sheet? Ctrl + F Ctrl + R Ctrl + H Ctrl + Shift + R9. All of the above Now () Date () Today () Time ()10. Which shortcut key is used to comment to cell Shift + F2 F2 F3 Ctrl + F211. Microsoft Excel is a powerful ________ Word processing package Spreadsheet package Communication S/W Package DBMS package12. You can activate a cell by Pressing the Tab key Pressing an arrow key All of the above Clicking the cell13. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Across Merge & Center Merge Cell Unmerge ell14. ____________ is shortcut to find and replace in ms excel. Shift + H Shift + F Ctrl + F Ctrl + H15. An Excel Workbook is a collection of ________ Charts Worksheets Worksheets and Charts Workbooks16. Which of the following is not a term of MS-Excel? Columns Document Rows Cells17. What is the shortcut key to replace a data with another in sheet? Ctrl + H Ctrl + R Ctrl + F Ctrl + Shift + R18. A formula in Excel always begins with an ____ Sign Equal Plus Multiply Minus19. Which shortcut key is used to comment to cell F3 F2 Shift + F2 Ctrl + F220. Which of the following is not a term of MS-Excel? Rows Columns Cells Document21. How many worksheets can we added in a workbook? 256 255 257 10522. Which is used to perform what if analysis? Scenario Manager Goal seek Data Table All of these23. The first cell in excel worksheet is _______ AA A1 AB B124. Which Chart can be created in Excel? All of the these Line pie Area25. ____________ Option is used to copy formatting from one cell to other cell . Format Painter Painter Format Cleaner Format26. which shortcuty key is used to edit a cell ? Ctrl + 7 F2 F4 F927. Excel is a program that is used to prepare a Slide presentation Spreadsheet Database Text document28. Which term is used to join the selected cells in to one cell? Clear formatting Wrap text wrap Merge & Center29. A ________ is a grid with labeled columns and rows. Worksheet Clipboard Toolbar Dialog box30. Excel is a program that is used to prepare a Spreadsheet Database Slide presentation Text document31. The value of cell is displayed in View Review Formula bar Name box32. Which term is used to join the selected cells in to one cell? Clear formatting Merge & Center wrap Wrap text33. Can we view gridline and heading in print preview ? Yes No34. MS-EXCEL is based on ________ OS/2 DOS WINDOWS UNIX35. All of the above Now () Today () Time () Date ()36. which shortcuty key is used to edit a cell ? F2 F4 F9 Ctrl + 737. 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 key38. Can we use formula bar to edit formula ? No Yes39. What is extension of excel 2013 ? xlsm xlxs. xlsx xlx40. Which key do you press to check spelling? F6 F7 F12 F441. Which of the following methods are used to edit cell Name box F2 Formula tab F142. Which of the following methods cannot be used to enter data in a cell Clicking on the formula bar Pressing an arrow key Pressing the Esc key Pressing the Tab key43. Microsoft Excel is a powerful ________ Spreadsheet package Communication S/W Package DBMS package Word processing package44. 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 exit45. Can we use table in excel to create filter ? Yes No46. Comments put in cells are called Cell Tip Smart Tip Web Tip Soft Tip47. The value of cell is displayed in Name box Formula bar Review View48. What is extension of excel 2013 ? xlsm xlsx xlxs. xlx49. Which Chart can be created in Excel? Area pie All of the these Line50. Can we view gridline and heading in print preview ? Yes No51. To activate Microsoft excel through run command, the keyword is microsoftexcel Winexcel Excel Msexcel52. A ________ is a grid with labeled columns and rows. Toolbar Worksheet Dialog box Clipboard53. Can we use formula bar to edit formula ? No Yes54. How many worksheets can we added in a workbook? 257 256 255 10555. Excel displays the current cell address in the ________ Status Bar Title Bar Formula bar Name Box56. MS-EXCEL is based on ________ WINDOWS OS/2 UNIX DOS57. Excel displays the current cell address in the ________ Status Bar Formula bar Name Box Title Bar58. Which area in an Excel window allows entering values and formulas? Formula Bar Title Bar Menu Bar Standard Tool Bar59. Which is used to perform what if analysis? All of these Scenario Manager Goal seek Data Table60. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Across Merge Cell Unmerge ell Merge & Center61. A formula in Excel always begins with an ____ Sign Minus Plus Multiply Equal 62. ____________ is shortcut to find and replace in ms excel. Ctrl + F Ctrl + H Shift + H Shift + F63. ____________ Option is used to copy formatting from one cell to other cell . Painter Format Cleaner Format Format Painter64. You can activate a cell by Pressing an arrow key Pressing the Tab key All of the above Clicking the cell65. An Excel Workbook is a collection of ________ Worksheets Worksheets and Charts Workbooks Charts66. Which area in an Excel window allows entering values and formulas? Menu Bar Standard Tool Bar Formula Bar Title Bar67. Which of the following is not the correct method of editing the cell content? Press the F2 key Press the Alt key Double click the cell Click the formula bar68. Comments put in cells are called Cell Tip Web Tip Soft Tip Smart Tip Loading …Question 1 of 68