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. The value of cell is displayed in Review Name box Formula bar View2. Which of the following is not a term of MS-Excel? Cells Columns Rows Document3. A ________ is a grid with labeled columns and rows. Dialog box Worksheet Toolbar Clipboard4. An Excel Workbook is a collection of ________ Worksheets and Charts Charts Worksheets Workbooks5. Which key do you press to check spelling? F4 F6 F12 F76. A formula in Excel always begins with an ____ Sign Multiply Plus Equal Minus7. Which of the following methods are used to edit cell F1 Name box Formula tab F28. Excel is a program that is used to prepare a Spreadsheet Database Text document Slide presentation9. To close MS Word which of the following method can we use Click on Close button Click on view Click on Close button Click on File tab button, then exit10. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Across Merge Cell Merge & Center Unmerge ell11. What is the shortcut key to replace a data with another in sheet? Ctrl + F Ctrl + Shift + R Ctrl + H Ctrl + R12. ____________ Option is used to copy formatting from one cell to other cell . Format Format Cleaner Painter Format Painter13. The first cell in excel worksheet is _______ A1 B1 AA AB14. Which key do you press to check spelling? F12 F7 F6 F415. To activate Microsoft excel through run command, the keyword is microsoftexcel Msexcel Excel Winexcel16. ____________ is shortcut to find and replace in ms excel. Shift + F Ctrl + H Ctrl + F Shift + H17. An Excel Workbook is a collection of ________ Worksheets Charts Workbooks Worksheets and Charts18. What is extension of excel 2013 ? xlx xlsx xlsm xlxs.19. Can we use table in excel to create filter ? Yes No20. Which area in an Excel window allows entering values and formulas? Standard Tool Bar Menu Bar Formula Bar Title Bar21. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Across Unmerge ell Merge Cell Merge & Center22. What is the shortcut key to replace a data with another in sheet? Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F23. A formula in Excel always begins with an ____ Sign Multiply Equal Minus Plus 24. Which shortcut key is used to comment to cell Shift + F2 F2 F3 Ctrl + F225. MS-EXCEL is based on ________ DOS OS/2 WINDOWS UNIX26. Microsoft Excel is a powerful ________ Word processing package Spreadsheet package Communication S/W Package DBMS package27. MS-EXCEL is based on ________ DOS UNIX WINDOWS OS/228. ____________ is shortcut to find and replace in ms excel. Shift + F Ctrl + H Shift + H Ctrl + F29. which shortcuty key is used to edit a cell ? F2 Ctrl + 7 F9 F430. Can we view gridline and heading in print preview ? No Yes31. Which shortcut key is used to comment to cell F2 Shift + F2 F3 Ctrl + F232. You can activate a cell by Pressing the Tab key All of the above Pressing an arrow key Clicking the cell33. To activate Microsoft excel through run command, the keyword is Excel Winexcel Msexcel microsoftexcel34. Which of the following methods cannot be used to enter data in a cell Pressing an arrow key Pressing the Esc key Clicking on the formula bar Pressing the Tab key35. which shortcuty key is used to edit a cell ? Ctrl + 7 F9 F2 F436. What is extension of excel 2013 ? xlsx xlxs. xlsm xlx37. Which of the following methods cannot be used to enter data in a cell Pressing the Tab key Pressing the Esc key Clicking on the formula bar Pressing an arrow key38. ____________ Option is used to copy formatting from one cell to other cell . Format Painter Format Painter Format Cleaner39. Which is used to perform what if analysis? Goal seek All of these Data Table Scenario Manager40. Comments put in cells are called Cell Tip Smart Tip Soft Tip Web Tip41. A ________ is a grid with labeled columns and rows. Worksheet Dialog box Clipboard Toolbar42. 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 key43. Comments put in cells are called Smart Tip Cell Tip Soft Tip Web Tip44. How many worksheets can we added in a workbook? 257 256 105 25545. Which is used to perform what if analysis? All of these Data Table Goal seek Scenario Manager46. Which of the following methods are used to edit cell Formula tab F2 Name box F147. Can we view gridline and heading in print preview ? Yes No48. Can we use table in excel to create filter ? No Yes49. Which area in an Excel window allows entering values and formulas? Menu Bar Title Bar Formula Bar Standard Tool Bar50. All of the above Time () Date () Now () Today ()51. Can we use formula bar to edit formula ? Yes No52. How many worksheets can we added in a workbook? 105 256 257 25553. Which of the following is not the correct method of editing the cell content? Double click the cell Press the Alt key Press the F2 key Click the formula bar54. Microsoft Excel is a powerful ________ DBMS package Spreadsheet package Word processing package Communication S/W Package55. You can activate a cell by Clicking the cell Pressing the Tab key Pressing an arrow key All of the above56. Excel displays the current cell address in the ________ Status Bar Title Bar Name Box Formula bar57. To close MS Word which of the following method can we use Click on view Click on File tab button, then exit Click on Close button Click on Close button58. Excel is a program that is used to prepare a Spreadsheet Database Slide presentation Text document59. Which Chart can be created in Excel? All of the these Line pie Area60. Which term is used to join the selected cells in to one cell? wrap Wrap text Clear formatting Merge & Center61. Which of the following is not a term of MS-Excel? Rows Cells Document Columns62. The first cell in excel worksheet is _______ A1 AA AB B163. All of the above Date () Today () Now () Time ()64. Excel displays the current cell address in the ________ Formula bar Status Bar Title Bar Name Box65. Which Chart can be created in Excel? All of the these Area pie Line66. The value of cell is displayed in Review Formula bar Name box View67. Can we use formula bar to edit formula ? Yes No68. Which term is used to join the selected cells in to one cell? Wrap text Merge & Center wrap Clear formatting Loading …Question 1 of 68