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. An Excel Workbook is a collection of ________ Workbooks Charts Worksheets and Charts Worksheets2. ____________ is shortcut to find and replace in ms excel. Ctrl + H Ctrl + F Shift + H Shift + F3. 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 bar4. How many worksheets can we added in a workbook? 255 105 257 2565. A formula in Excel always begins with an ____ Sign Minus Plus Equal Multiply6. ____________ Option is used to copy formatting from one cell to other cell . Painter Format Format Cleaner Format Painter7. Which area in an Excel window allows entering values and formulas? Formula Bar Title Bar Standard Tool Bar Menu Bar8. MS-EXCEL is based on ________ DOS UNIX OS/2 WINDOWS9. To activate Microsoft excel through run command, the keyword is microsoftexcel Winexcel Excel Msexcel10. Which key do you press to check spelling? F4 F7 F6 F1211. Which of the following methods cannot be used to enter data in a cell Pressing the Esc key Pressing an arrow key Pressing the Tab key Clicking on the formula bar12. A ________ is a grid with labeled columns and rows. Dialog box Toolbar Clipboard Worksheet13. Which Chart can be created in Excel? Line Area pie All of the these14. Which of the following methods are used to edit cell Name box F1 F2 Formula tab15. You can activate a cell by Pressing the Tab key All of the above Clicking the cell Pressing an arrow key16. Which of the following is not a term of MS-Excel? Cells Document Rows Columns17. A formula in Excel always begins with an ____ Sign Minus Equal Multiply Plus 18. 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 key19. The value of cell is displayed in Name box View Review Formula bar20. Which term is used to join the selected cells in to one cell? wrap Merge & Center Wrap text Clear formatting21. Can we use table in excel to create filter ? No Yes22. Which Chart can be created in Excel? pie All of the these Area Line23. Which of the following is not a term of MS-Excel? Cells Rows Document Columns24. All of the above Date () Today () Time () Now ()25. Which key do you press to check spelling? F4 F7 F6 F1226. Comments put in cells are called Soft Tip Smart Tip Web Tip Cell Tip27. Microsoft Excel is a powerful ________ Spreadsheet package Communication S/W Package Word processing package DBMS package28. What is extension of excel 2013 ? xlxs. xlx xlsm xlsx29. The value of cell is displayed in Name box Review View Formula bar30. Which shortcut key is used to comment to cell Ctrl + F2 F2 Shift + F2 F331. Can we use formula bar to edit formula ? Yes No32. which shortcuty key is used to edit a cell ? F9 F2 F4 Ctrl + 733. Which is used to perform what if analysis? Scenario Manager Data Table All of these Goal seek34. The first cell in excel worksheet is _______ B1 AB AA A135. Which of the following is not the correct method of editing the cell content? Press the Alt key Press the F2 key Double click the cell Click the formula bar36. Which term is used to join the selected cells in to one cell? Merge & Center wrap Clear formatting Wrap text37. which shortcuty key is used to edit a cell ? F2 F4 Ctrl + 7 F938. Can we use table in excel to create filter ? No Yes39. Excel displays the current cell address in the ________ Status Bar Formula bar Name Box Title Bar40. Which option is used to join the selected cells into single cell and center the content of cell ? Merge & Center Unmerge ell Merge Across Merge Cell41. 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 Close button Click on view42. Which shortcut key is used to comment to cell Shift + F2 F2 F3 Ctrl + F243. MS-EXCEL is based on ________ DOS UNIX OS/2 WINDOWS44. Can we view gridline and heading in print preview ? Yes No45. How many worksheets can we added in a workbook? 105 255 256 25746. 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 view47. Microsoft Excel is a powerful ________ DBMS package Spreadsheet package Word processing package Communication S/W Package48. Which of the following methods are used to edit cell F1 F2 Name box Formula tab49. Comments put in cells are called Soft Tip Web Tip Cell Tip Smart Tip50. Excel is a program that is used to prepare a Text document Slide presentation Spreadsheet Database51. ____________ is shortcut to find and replace in ms excel. Ctrl + F Shift + F Shift + H Ctrl + H52. Can we use formula bar to edit formula ? No Yes53. What is the shortcut key to replace a data with another in sheet? Ctrl + F Ctrl + R Ctrl + Shift + R Ctrl + H54. All of the above Time () Today () Date () Now ()55. ____________ Option is used to copy formatting from one cell to other cell . Format Cleaner Painter Format Format Painter56. Which area in an Excel window allows entering values and formulas? Standard Tool Bar Title Bar Formula Bar Menu Bar57. What is extension of excel 2013 ? xlx xlsm xlxs. xlsx58. You can activate a cell by Pressing an arrow key All of the above Clicking the cell Pressing the Tab key59. A ________ is a grid with labeled columns and rows. Dialog box Worksheet Toolbar Clipboard60. An Excel Workbook is a collection of ________ Charts Worksheets Worksheets and Charts Workbooks61. Excel is a program that is used to prepare a Slide presentation Database Text document Spreadsheet62. To activate Microsoft excel through run command, the keyword is microsoftexcel Excel Msexcel Winexcel63. Excel displays the current cell address in the ________ Name Box Formula bar Status Bar Title Bar64. What is the shortcut key to replace a data with another in sheet? Ctrl + H Ctrl + Shift + R Ctrl + R Ctrl + F65. Can we view gridline and heading in print preview ? No Yes66. Which is used to perform what if analysis? Scenario Manager All of these Goal seek Data Table67. 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 ell68. The first cell in excel worksheet is _______ AA AB B1 A1 Loading …Question 1 of 68