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 Formula bar View Name box Review2. The first cell in excel worksheet is _______ AA A1 AB B13. Which of the following methods are used to edit cell F1 Name box Formula tab F24. Microsoft Excel is a powerful ________ Spreadsheet package Word processing package DBMS package Communication S/W Package5. The first cell in excel worksheet is _______ B1 AB AA A16. Which of the following is not the correct method of editing the cell content? Press the F2 key Double click the cell Press the Alt key Click the formula bar7. Can we use formula bar to edit formula ? No Yes8. Which Chart can be created in Excel? pie All of the these Area Line9. 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 key10. ____________ is shortcut to find and replace in ms excel. Ctrl + H Shift + H Ctrl + F Shift + F11. Can we view gridline and heading in print preview ? No Yes12. Which key do you press to check spelling? F4 F12 F6 F713. Comments put in cells are called Smart Tip Cell Tip Soft Tip Web Tip14. How many worksheets can we added in a workbook? 256 255 257 10515. Excel is a program that is used to prepare a Database Slide presentation Text document Spreadsheet16. Which area in an Excel window allows entering values and formulas? Formula Bar Standard Tool Bar Title Bar Menu Bar17. An Excel Workbook is a collection of ________ Worksheets Worksheets and Charts Charts Workbooks18. 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 ell19. Which area in an Excel window allows entering values and formulas? Menu Bar Standard Tool Bar Title Bar Formula Bar20. All of the above Now () Time () Today () Date ()21. A ________ is a grid with labeled columns and rows. Dialog box Toolbar Worksheet Clipboard22. Can we use formula bar to edit formula ? No Yes23. What is extension of excel 2013 ? xlxs. xlsm xlsx xlx24. Which of the following is not a term of MS-Excel? Cells Rows Columns Document25. A formula in Excel always begins with an ____ Sign Equal Plus Minus Multiply26. which shortcuty key is used to edit a cell ? F9 F2 Ctrl + 7 F427. Excel is a program that is used to prepare a Spreadsheet Slide presentation Database Text document28. Which option is used to join the selected cells into single cell and center the content of cell ? Merge & Center Merge Cell Unmerge ell Merge Across29. Which shortcut key is used to comment to cell Shift + F2 Ctrl + F2 F2 F330. MS-EXCEL is based on ________ WINDOWS OS/2 DOS UNIX31. The value of cell is displayed in Name box View Review Formula bar32. Which is used to perform what if analysis? Goal seek Data Table All of these Scenario Manager33. Which of the following is not a term of MS-Excel? Columns Document Rows Cells34. 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 exit35. Excel displays the current cell address in the ________ Title Bar Formula bar Name Box Status Bar36. Can we use table in excel to create filter ? Yes No37. What is the shortcut key to replace a data with another in sheet? Ctrl + Shift + R Ctrl + F Ctrl + H Ctrl + R38. Which Chart can be created in Excel? Line All of the these Area pie39. 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 exit40. Can we view gridline and heading in print preview ? Yes No41. You can activate a cell by All of the above Pressing an arrow key Pressing the Tab key Clicking the cell42. 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 Tab key Pressing the Esc key43. Which term is used to join the selected cells in to one cell? Wrap text wrap Clear formatting Merge & Center44. Which term is used to join the selected cells in to one cell? wrap Wrap text Clear formatting Merge & Center45. Microsoft Excel is a powerful ________ Word processing package Communication S/W Package DBMS package Spreadsheet package46. ____________ is shortcut to find and replace in ms excel. Shift + H Ctrl + F Shift + F Ctrl + H47. Which of the following methods are used to edit cell Name box F1 Formula tab F248. All of the above Today () Time () Date () Now ()49. Which of the following methods cannot be used to enter data in a cell Clicking on the formula bar Pressing the Esc key Pressing the Tab key Pressing an arrow key50. To activate Microsoft excel through run command, the keyword is Excel Winexcel microsoftexcel Msexcel51. Comments put in cells are called Web Tip Smart Tip Soft Tip Cell Tip52. Which shortcut key is used to comment to cell F2 F3 Shift + F2 Ctrl + F253. A ________ is a grid with labeled columns and rows. Dialog box Worksheet Clipboard Toolbar54. You can activate a cell by Pressing the Tab key Clicking the cell All of the above Pressing an arrow key55. What is the shortcut key to replace a data with another in sheet? Ctrl + F Ctrl + H Ctrl + Shift + R Ctrl + R56. Can we use table in excel to create filter ? Yes No57. which shortcuty key is used to edit a cell ? F4 F9 Ctrl + 7 F258. What is extension of excel 2013 ? xlxs. xlx xlsm xlsx59. ____________ Option is used to copy formatting from one cell to other cell . Format Cleaner Format Format Painter Painter60. Excel displays the current cell address in the ________ Formula bar Status Bar Title Bar Name Box61. ____________ Option is used to copy formatting from one cell to other cell . Format Format Painter Format Cleaner Painter62. A formula in Excel always begins with an ____ Sign Minus Equal Multiply Plus 63. To activate Microsoft excel through run command, the keyword is Msexcel Winexcel Excel microsoftexcel64. How many worksheets can we added in a workbook? 256 105 257 25565. MS-EXCEL is based on ________ UNIX OS/2 DOS WINDOWS66. Which key do you press to check spelling? F7 F4 F6 F1267. An Excel Workbook is a collection of ________ Worksheets Workbooks Worksheets and Charts Charts68. Which is used to perform what if analysis? Scenario Manager Goal seek Data Table All of these Loading …Question 1 of 68