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. Can we use formula bar to edit formula ? No Yes2. Excel displays the current cell address in the ________ Name Box Title Bar Status Bar Formula bar3. Can we view gridline and heading in print preview ? Yes No4. What is the shortcut key to replace a data with another in sheet? Ctrl + R Ctrl + H Ctrl + F Ctrl + Shift + R5. ____________ is shortcut to find and replace in ms excel. Ctrl + F Ctrl + H Shift + H Shift + F6. Which of the following is not a term of MS-Excel? Rows Cells Document Columns7. Which of the following is not a term of MS-Excel? Rows Document Cells Columns8. Can we view gridline and heading in print preview ? Yes No9. Which is used to perform what if analysis? Goal seek Data Table All of these Scenario Manager10. Excel displays the current cell address in the ________ Formula bar Title Bar Name Box Status Bar11. Can we use table in excel to create filter ? Yes No12. Which area in an Excel window allows entering values and formulas? Title Bar Menu Bar Standard Tool Bar Formula Bar13. An Excel Workbook is a collection of ________ Charts Worksheets and Charts Worksheets Workbooks14. Which Chart can be created in Excel? Line Area pie All of the these15. 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 key16. 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 key17. Comments put in cells are called Smart Tip Cell Tip Web Tip Soft Tip18. Which area in an Excel window allows entering values and formulas? Menu Bar Title Bar Formula Bar Standard Tool Bar19. MS-EXCEL is based on ________ DOS WINDOWS UNIX OS/220. How many worksheets can we added in a workbook? 255 256 257 10521. Which key do you press to check spelling? F7 F12 F4 F622. You can activate a cell by Clicking the cell Pressing an arrow key All of the above Pressing the Tab key23. 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 view24. Excel is a program that is used to prepare a Text document Slide presentation Spreadsheet Database25. What is the shortcut key to replace a data with another in sheet? Ctrl + H Ctrl + Shift + R Ctrl + F Ctrl + R26. Can we use table in excel to create filter ? No Yes27. Excel is a program that is used to prepare a Text document Database Spreadsheet Slide presentation28. To activate Microsoft excel through run command, the keyword is Excel microsoftexcel Winexcel Msexcel29. The value of cell is displayed in Formula bar Name box Review View30. Comments put in cells are called Cell Tip Soft Tip Smart Tip Web Tip31. 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 Cell32. Which of the following methods are used to edit cell F1 F2 Formula tab Name box33. All of the above Time () Date () Now () Today ()34. ____________ Option is used to copy formatting from one cell to other cell . Format Cleaner Painter Format Painter Format35. 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 key36. A formula in Excel always begins with an ____ Sign Plus Multiply Minus Equal 37. What is extension of excel 2013 ? xlsm xlx xlxs. xlsx38. The value of cell is displayed in Name box Review View Formula bar39. A formula in Excel always begins with an ____ Sign Minus Multiply Plus Equal 40. Which of the following methods are used to edit cell Name box F1 F2 Formula tab41. What is extension of excel 2013 ? xlsm xlxs. xlsx xlx42. A ________ is a grid with labeled columns and rows. Worksheet Clipboard Toolbar Dialog box43. Which shortcut key is used to comment to cell F3 F2 Shift + F2 Ctrl + F244. 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 exit45. Microsoft Excel is a powerful ________ DBMS package Communication S/W Package Word processing package Spreadsheet package46. The first cell in excel worksheet is _______ AA B1 A1 AB47. Which key do you press to check spelling? F4 F6 F7 F1248. A ________ is a grid with labeled columns and rows. Clipboard Worksheet Toolbar Dialog box49. Which term is used to join the selected cells in to one cell? Wrap text wrap Clear formatting Merge & Center50. Which shortcut key is used to comment to cell Ctrl + F2 F2 F3 Shift + F251. The first cell in excel worksheet is _______ AB A1 AA B152. You can activate a cell by All of the above Pressing the Tab key Clicking the cell Pressing an arrow key53. 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. MS-EXCEL is based on ________ OS/2 DOS UNIX WINDOWS55. Can we use formula bar to edit formula ? Yes No56. ____________ Option is used to copy formatting from one cell to other cell . Format Cleaner Format Painter Format Painter57. Which is used to perform what if analysis? Data Table All of these Goal seek Scenario Manager58. which shortcuty key is used to edit a cell ? F4 F2 F9 Ctrl + 759. An Excel Workbook is a collection of ________ Workbooks Charts Worksheets Worksheets and Charts60. Which term is used to join the selected cells in to one cell? Clear formatting Wrap text wrap Merge & Center61. To activate Microsoft excel through run command, the keyword is Winexcel Excel Msexcel microsoftexcel62. which shortcuty key is used to edit a cell ? F9 F4 Ctrl + 7 F263. ____________ is shortcut to find and replace in ms excel. Shift + H Ctrl + F Ctrl + H Shift + F64. Microsoft Excel is a powerful ________ Communication S/W Package Word processing package DBMS package Spreadsheet package65. Which Chart can be created in Excel? Area All of the these pie Line66. How many worksheets can we added in a workbook? 105 257 255 25667. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Cell Merge & Center Unmerge ell Merge Across68. All of the above Now () Today () Time () Date () Loading …Question 1 of 68