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. What is the shortcut key to replace a data with another in sheet? Ctrl + F Ctrl + R Ctrl + Shift + R Ctrl + H2. The first cell in excel worksheet is _______ AB B1 AA A13. Can we view gridline and heading in print preview ? No Yes4. Excel is a program that is used to prepare a Text document Spreadsheet Database Slide presentation5. ____________ is shortcut to find and replace in ms excel. Ctrl + H Shift + H Ctrl + F Shift + F6. which shortcuty key is used to edit a cell ? Ctrl + 7 F2 F4 F97. Excel displays the current cell address in the ________ Name Box Title Bar Formula bar Status Bar8. The first cell in excel worksheet is _______ AB AA A1 B19. A formula in Excel always begins with an ____ Sign Multiply Equal Plus Minus10. Which of the following methods cannot be used to enter data in a cell Pressing the Tab key Pressing an arrow key Pressing the Esc key Clicking on the formula bar11. Can we use table in excel to create filter ? Yes No12. The value of cell is displayed in Name box Review View Formula bar13. What is extension of excel 2013 ? xlxs. xlsx xlx xlsm14. Which of the following methods cannot be used to enter data in a cell Pressing the Tab key Pressing an arrow key Pressing the Esc key Clicking on the formula bar15. To activate Microsoft excel through run command, the keyword is Winexcel microsoftexcel Excel Msexcel16. Which key do you press to check spelling? F4 F6 F12 F717. You can activate a cell by Pressing the Tab key Pressing an arrow key All of the above Clicking the cell18. Which of the following methods are used to edit cell Formula tab Name box F2 F119. Which is used to perform what if analysis? Goal seek All of these Scenario Manager Data Table20. An Excel Workbook is a collection of ________ Worksheets Charts Worksheets and Charts Workbooks21. Which Chart can be created in Excel? pie Area All of the these Line22. Which is used to perform what if analysis? Scenario Manager All of these Data Table Goal seek23. MS-EXCEL is based on ________ OS/2 UNIX WINDOWS DOS24. ____________ Option is used to copy formatting from one cell to other cell . Format Cleaner Format Format Painter Painter25. What is extension of excel 2013 ? xlsm xlx xlxs. xlsx26. Which of the following methods are used to edit cell Name box F2 F1 Formula tab27. Microsoft Excel is a powerful ________ Word processing package Spreadsheet package Communication S/W Package DBMS package28. Which area in an Excel window allows entering values and formulas? Title Bar Formula Bar Standard Tool Bar Menu Bar29. Which area in an Excel window allows entering values and formulas? Standard Tool Bar Menu Bar Title Bar Formula Bar30. Which option is used to join the selected cells into single cell and center the content of cell ? Unmerge ell Merge Cell Merge & Center Merge Across31. All of the above Date () Today () Time () Now ()32. Can we view gridline and heading in print preview ? Yes No33. 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 view34. The value of cell is displayed in Name box View Formula bar Review35. Which of the following is not a term of MS-Excel? Rows Cells Document Columns36. A ________ is a grid with labeled columns and rows. Worksheet Dialog box Toolbar Clipboard37. Which of the following is not a term of MS-Excel? Document Rows Columns Cells38. To activate Microsoft excel through run command, the keyword is Excel Winexcel Msexcel microsoftexcel39. Can we use table in excel to create filter ? No Yes40. You can activate a cell by All of the above Pressing the Tab key Pressing an arrow key Clicking the cell41. Which term is used to join the selected cells in to one cell? Clear formatting Merge & Center wrap Wrap text42. Which shortcut key is used to comment to cell F3 F2 Ctrl + F2 Shift + F243. Which Chart can be created in Excel? Line All of the these Area pie44. Comments put in cells are called Web Tip Soft Tip Cell Tip Smart Tip45. Excel is a program that is used to prepare a Database Slide presentation Spreadsheet Text document46. An Excel Workbook is a collection of ________ Worksheets and Charts Charts Workbooks Worksheets47. Can we use formula bar to edit formula ? No Yes48. which shortcuty key is used to edit a cell ? F2 F4 F9 Ctrl + 749. ____________ Option is used to copy formatting from one cell to other cell . Format Cleaner Painter Format Format Painter50. 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 button51. ____________ is shortcut to find and replace in ms excel. Ctrl + F Shift + H Shift + F Ctrl + H52. What is the shortcut key to replace a data with another in sheet? Ctrl + R Ctrl + Shift + R Ctrl + F Ctrl + H53. How many worksheets can we added in a workbook? 255 256 105 25754. A formula in Excel always begins with an ____ Sign Equal Plus Multiply Minus55. 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 Across56. Which of the following is not the correct method of editing the cell content? Press the Alt key Click the formula bar Double click the cell Press the F2 key57. Can we use formula bar to edit formula ? Yes No58. Excel displays the current cell address in the ________ Status Bar Formula bar Title Bar Name Box59. Which of the following is not the correct method of editing the cell content? Press the Alt key Click the formula bar Double click the cell Press the F2 key60. How many worksheets can we added in a workbook? 257 256 255 10561. All of the above Now () Time () Today () Date ()62. Which shortcut key is used to comment to cell Ctrl + F2 F2 F3 Shift + F263. Which term is used to join the selected cells in to one cell? Wrap text Merge & Center Clear formatting wrap64. A ________ is a grid with labeled columns and rows. Dialog box Clipboard Toolbar Worksheet65. Which key do you press to check spelling? F4 F6 F7 F1266. Microsoft Excel is a powerful ________ Word processing package DBMS package Communication S/W Package Spreadsheet package67. Comments put in cells are called Smart Tip Soft Tip Web Tip Cell Tip68. MS-EXCEL is based on ________ UNIX WINDOWS OS/2 DOS Loading …Question 1 of 68