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 is a program that is used to prepare a Spreadsheet Text document Slide presentation Database2. MS-EXCEL is based on ________ WINDOWS OS/2 UNIX DOS3. Which is used to perform what if analysis? Scenario Manager Goal seek All of these Data Table4. Which is used to perform what if analysis? All of these Data Table Scenario Manager Goal seek5. Which area in an Excel window allows entering values and formulas? Menu Bar Title Bar Standard Tool Bar Formula Bar6. You can activate a cell by Pressing an arrow key Clicking the cell All of the above Pressing the Tab key7. Which of the following methods are used to edit cell F1 Name box Formula tab F28. How many worksheets can we added in a workbook? 256 255 105 2579. Which of the following is not a term of MS-Excel? Cells Columns Rows Document10. 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 exit11. Which Chart can be created in Excel? Line pie All of the these Area12. Excel displays the current cell address in the ________ Name Box Formula bar Title Bar Status Bar13. Which shortcut key is used to comment to cell F3 F2 Ctrl + F2 Shift + F214. An Excel Workbook is a collection of ________ Worksheets and Charts Worksheets Workbooks Charts15. Which of the following methods cannot be used to enter data in a cell Pressing the Esc key Pressing the Tab key Pressing an arrow key Clicking on the formula bar16. Comments put in cells are called Soft Tip Smart Tip Cell Tip Web Tip17. Which key do you press to check spelling? F12 F7 F6 F418. A ________ is a grid with labeled columns and rows. Worksheet Toolbar Clipboard Dialog box19. All of the above Time () Today () Date () Now ()20. Excel displays the current cell address in the ________ Title Bar Formula bar Status Bar Name Box21. ____________ Option is used to copy formatting from one cell to other cell . Painter Format Painter Format Cleaner Format22. What is extension of excel 2013 ? xlsm xlsx xlx xlxs.23. 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 view Click on Close button24. All of the above Date () Time () Today () Now ()25. Which of the following is not a term of MS-Excel? Document Columns Rows Cells26. An Excel Workbook is a collection of ________ Worksheets and Charts Workbooks Charts Worksheets27. You can activate a cell by Pressing the Tab key Pressing an arrow key Clicking the cell All of the above28. Which Chart can be created in Excel? pie Line Area All of the these29. Can we use formula bar to edit formula ? No Yes30. Which of the following is not the correct method of editing the cell content? Double click the cell Press the F2 key Click the formula bar Press the Alt key31. The value of cell is displayed in View Name box Formula bar Review32. What is the shortcut key to replace a data with another in sheet? Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H33. To activate Microsoft excel through run command, the keyword is Winexcel microsoftexcel Excel Msexcel34. Can we view gridline and heading in print preview ? Yes No35. A formula in Excel always begins with an ____ Sign Plus Multiply Equal Minus36. A formula in Excel always begins with an ____ Sign Minus Multiply Equal Plus 37. What is extension of excel 2013 ? xlsm xlxs. xlx xlsx38. To activate Microsoft excel through run command, the keyword is Excel microsoftexcel Winexcel Msexcel39. A ________ is a grid with labeled columns and rows. Dialog box Toolbar Worksheet Clipboard40. Which option is used to join the selected cells into single cell and center the content of cell ? Unmerge ell Merge Across Merge Cell Merge & Center41. Microsoft Excel is a powerful ________ Spreadsheet package Communication S/W Package DBMS package Word processing package42. ____________ is shortcut to find and replace in ms excel. Shift + H Ctrl + F Shift + F Ctrl + H43. Microsoft Excel is a powerful ________ DBMS package Spreadsheet package Word processing package Communication S/W Package44. What is the shortcut key to replace a data with another in sheet? Ctrl + H Ctrl + F Ctrl + Shift + R Ctrl + R45. The value of cell is displayed in Name box Formula bar View Review46. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Across Unmerge ell Merge & Center Merge Cell47. ____________ Option is used to copy formatting from one cell to other cell . Format Painter Painter Format Cleaner Format48. Which of the following is not the correct method of editing the cell content? Press the F2 key Press the Alt key Click the formula bar Double click the cell49. Comments put in cells are called Web Tip Cell Tip Soft Tip Smart Tip50. The first cell in excel worksheet is _______ A1 AB B1 AA51. Which area in an Excel window allows entering values and formulas? Formula Bar Title Bar Menu Bar Standard Tool Bar52. Which key do you press to check spelling? F6 F7 F4 F1253. MS-EXCEL is based on ________ DOS WINDOWS UNIX OS/254. which shortcuty key is used to edit a cell ? F9 Ctrl + 7 F4 F255. Which of the following methods are used to edit cell Formula tab F1 F2 Name box56. Excel is a program that is used to prepare a Slide presentation Text document Database Spreadsheet57. Can we use formula bar to edit formula ? No Yes58. ____________ is shortcut to find and replace in ms excel. Ctrl + F Shift + H Ctrl + H Shift + F59. Can we use table in excel to create filter ? No Yes60. Can we view gridline and heading in print preview ? No Yes61. The first cell in excel worksheet is _______ B1 A1 AB AA62. which shortcuty key is used to edit a cell ? F9 F2 Ctrl + 7 F463. Which of the following methods cannot be used to enter data in a cell Pressing the Tab key Clicking on the formula bar Pressing the Esc key Pressing an arrow key64. Which term is used to join the selected cells in to one cell? Merge & Center wrap Clear formatting Wrap text65. Which term is used to join the selected cells in to one cell? Clear formatting Merge & Center wrap Wrap text66. Can we use table in excel to create filter ? No Yes67. How many worksheets can we added in a workbook? 256 105 257 25568. Which shortcut key is used to comment to cell F3 F2 Ctrl + F2 Shift + F2 Loading …Question 1 of 68