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. Which of the following is not a term of MS-Excel? Document Cells Rows Columns2. What is the shortcut key to replace a data with another in sheet? Ctrl + F Ctrl + R Ctrl + Shift + R Ctrl + H3. An Excel Workbook is a collection of ________ Workbooks Worksheets and Charts Charts Worksheets4. Which of the following is not a term of MS-Excel? Columns Document Rows Cells5. Can we use table in excel to create filter ? No Yes6. The value of cell is displayed in Formula bar View Name box Review7. Can we view gridline and heading in print preview ? No Yes8. To activate Microsoft excel through run command, the keyword is Msexcel Winexcel microsoftexcel Excel9. All of the above Date () Today () Now () Time ()10. The value of cell is displayed in Formula bar View Name box Review11. To close MS Word which of the following method can we use Click on Close button Click on view Click on File tab button, then exit Click on Close button12. Can we use formula bar to edit formula ? No Yes13. Which of the following is not the correct method of editing the cell content? Click the formula bar Press the F2 key Double click the cell Press the Alt key14. Can we use table in excel to create filter ? Yes No15. Comments put in cells are called Cell Tip Soft Tip Web Tip Smart Tip16. 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 view17. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Across Merge & Center Unmerge ell Merge Cell18. Which of the following methods cannot be used to enter data in a cell Pressing the Tab key Pressing the Esc key Pressing an arrow key Clicking on the formula bar19. ____________ Option is used to copy formatting from one cell to other cell . Format Painter Painter Format Cleaner Format20. The first cell in excel worksheet is _______ A1 AA AB B121. MS-EXCEL is based on ________ DOS WINDOWS UNIX OS/222. To activate Microsoft excel through run command, the keyword is Msexcel microsoftexcel Winexcel Excel23. A formula in Excel always begins with an ____ Sign Equal Plus Multiply Minus24. Microsoft Excel is a powerful ________ Communication S/W Package Word processing package Spreadsheet package DBMS package25. ____________ is shortcut to find and replace in ms excel. Ctrl + F Shift + H Ctrl + H Shift + F26. How many worksheets can we added in a workbook? 105 257 255 25627. ____________ Option is used to copy formatting from one cell to other cell . Format Painter Format Cleaner Format Painter28. Which area in an Excel window allows entering values and formulas? Title Bar Menu Bar Formula Bar Standard Tool Bar29. Which term is used to join the selected cells in to one cell? Merge & Center wrap Wrap text Clear formatting30. An Excel Workbook is a collection of ________ Workbooks Worksheets Charts Worksheets and Charts31. You can activate a cell by Pressing the Tab key Clicking the cell All of the above Pressing an arrow key32. What is extension of excel 2013 ? xlsm xlx xlsx xlxs.33. Which shortcut key is used to comment to cell Shift + F2 F3 F2 Ctrl + F234. Which key do you press to check spelling? F7 F12 F6 F435. Which key do you press to check spelling? F7 F6 F12 F436. Which shortcut key is used to comment to cell Shift + F2 Ctrl + F2 F3 F237. A formula in Excel always begins with an ____ Sign Minus Multiply Equal Plus 38. A ________ is a grid with labeled columns and rows. Worksheet Toolbar Clipboard Dialog box39. What is the shortcut key to replace a data with another in sheet? Ctrl + R Ctrl + H Ctrl + Shift + R Ctrl + F40. Excel displays the current cell address in the ________ Title Bar Status Bar Name Box Formula bar41. Excel is a program that is used to prepare a Slide presentation Text document Spreadsheet Database42. Which Chart can be created in Excel? pie Area All of the these Line43. Which of the following methods cannot be used to enter data in a cell Pressing the Tab key Clicking on the formula bar Pressing an arrow key Pressing the Esc key44. 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 bar45. Microsoft Excel is a powerful ________ Communication S/W Package Spreadsheet package DBMS package Word processing package46. Which Chart can be created in Excel? All of the these Area Line pie47. Which is used to perform what if analysis? Goal seek All of these Scenario Manager Data Table48. Can we use formula bar to edit formula ? Yes No49. Can we view gridline and heading in print preview ? Yes No50. ____________ is shortcut to find and replace in ms excel. Shift + F Shift + H Ctrl + H Ctrl + F51. Excel displays the current cell address in the ________ Title Bar Status Bar Formula bar Name Box52. Excel is a program that is used to prepare a Text document Spreadsheet Slide presentation Database53. How many worksheets can we added in a workbook? 255 256 105 25754. You can activate a cell by Clicking the cell Pressing the Tab key Pressing an arrow key All of the above55. Which of the following methods are used to edit cell Name box F2 Formula tab F156. Which of the following methods are used to edit cell Name box Formula tab F1 F257. A ________ is a grid with labeled columns and rows. Toolbar Worksheet Dialog box Clipboard58. Which is used to perform what if analysis? Data Table All of these Scenario Manager Goal seek59. All of the above Now () Time () Date () Today ()60. which shortcuty key is used to edit a cell ? F9 F4 F2 Ctrl + 761. Which term is used to join the selected cells in to one cell? Wrap text wrap Merge & Center Clear formatting62. Which option is used to join the selected cells into single cell and center the content of cell ? Unmerge ell Merge Cell Merge Across Merge & Center63. MS-EXCEL is based on ________ UNIX DOS OS/2 WINDOWS64. which shortcuty key is used to edit a cell ? F9 F2 F4 Ctrl + 765. What is extension of excel 2013 ? xlxs. xlsm xlx xlsx66. The first cell in excel worksheet is _______ B1 AA AB A167. Comments put in cells are called Cell Tip Smart Tip Web Tip Soft Tip68. Which area in an Excel window allows entering values and formulas? Formula Bar Standard Tool Bar Menu Bar Title Bar Loading …Question 1 of 68