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. A formula in Excel always begins with an ____ Sign Minus Equal Plus Multiply2. How many worksheets can we added in a workbook? 105 257 255 2563. The value of cell is displayed in Name box View Formula bar Review4. Which option is used to join the selected cells into single cell and center the content of cell ? Merge & Center Merge Across Merge Cell Unmerge ell5. Which key do you press to check spelling? F7 F4 F12 F66. The first cell in excel worksheet is _______ A1 B1 AA AB7. An Excel Workbook is a collection of ________ Workbooks Worksheets Charts Worksheets and Charts8. Excel displays the current cell address in the ________ Status Bar Name Box Formula bar Title Bar9. Microsoft Excel is a powerful ________ Communication S/W Package DBMS package Spreadsheet package Word processing package10. ____________ Option is used to copy formatting from one cell to other cell . Format Painter Format Format Cleaner Painter11. A formula in Excel always begins with an ____ Sign Minus Plus Multiply Equal 12. Which option is used to join the selected cells into single cell and center the content of cell ? Unmerge ell Merge & Center Merge Across Merge Cell13. Microsoft Excel is a powerful ________ DBMS package Word processing package Communication S/W Package Spreadsheet package14. Which term is used to join the selected cells in to one cell? Wrap text Merge & Center Clear formatting wrap15. Which area in an Excel window allows entering values and formulas? Menu Bar Standard Tool Bar Title Bar Formula Bar16. How many worksheets can we added in a workbook? 255 105 257 25617. An Excel Workbook is a collection of ________ Charts Worksheets Worksheets and Charts Workbooks18. Can we view gridline and heading in print preview ? No Yes19. To activate Microsoft excel through run command, the keyword is microsoftexcel Excel Msexcel Winexcel20. Which of the following methods cannot be used to enter data in a cell Pressing the Tab key Pressing an arrow key Clicking on the formula bar Pressing the Esc key21. Can we use table in excel to create filter ? No Yes22. Which of the following methods are used to edit cell F2 Name box F1 Formula tab23. Excel is a program that is used to prepare a Database Spreadsheet Slide presentation Text document24. Can we use formula bar to edit formula ? No Yes25. Which of the following methods are used to edit cell F2 Formula tab F1 Name box26. Which Chart can be created in Excel? All of the these Area pie Line27. Which of the following is not a term of MS-Excel? Columns Cells Document Rows28. To activate Microsoft excel through run command, the keyword is Winexcel Msexcel Excel microsoftexcel29. MS-EXCEL is based on ________ UNIX WINDOWS DOS OS/230. All of the above Now () Today () Time () Date ()31. 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 exit32. Which Chart can be created in Excel? Line pie All of the these Area33. The first cell in excel worksheet is _______ B1 AA AB A134. Which is used to perform what if analysis? Scenario Manager All of these Data Table Goal seek35. A ________ is a grid with labeled columns and rows. Worksheet Dialog box Toolbar Clipboard36. Excel is a program that is used to prepare a Spreadsheet Database Slide presentation Text document37. A ________ is a grid with labeled columns and rows. Clipboard Dialog box Worksheet Toolbar38. What is the shortcut key to replace a data with another in sheet? Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F39. Which key do you press to check spelling? F4 F7 F12 F640. Which is used to perform what if analysis? Goal seek Data Table Scenario Manager All of these41. Which term is used to join the selected cells in to one cell? Wrap text wrap Merge & Center Clear formatting42. 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 view43. Which area in an Excel window allows entering values and formulas? Menu Bar Formula Bar Title Bar Standard Tool Bar44. Which of the following is not the correct method of editing the cell content? Press the F2 key Press the Alt key Double click the cell Click the formula bar45. which shortcuty key is used to edit a cell ? F9 Ctrl + 7 F4 F246. What is extension of excel 2013 ? xlsm xlx xlsx xlxs.47. All of the above Now () Date () Time () Today ()48. Comments put in cells are called Web Tip Soft Tip Cell Tip Smart Tip49. Can we view gridline and heading in print preview ? Yes No50. Can we use formula bar to edit formula ? Yes No51. What is extension of excel 2013 ? xlxs. xlsx xlsm xlx52. Which of the following methods cannot be used to enter data in a cell Pressing an arrow key Pressing the Tab key Clicking on the formula bar Pressing the Esc key53. What is the shortcut key to replace a data with another in sheet? Ctrl + F Ctrl + R Ctrl + Shift + R Ctrl + H54. Which shortcut key is used to comment to cell Shift + F2 F2 Ctrl + F2 F355. Which of the following is not a term of MS-Excel? Rows Document Cells Columns56. ____________ is shortcut to find and replace in ms excel. Ctrl + F Shift + H Shift + F Ctrl + H57. You can activate a cell by Clicking the cell All of the above Pressing the Tab key Pressing an arrow key58. Comments put in cells are called Soft Tip Smart Tip Web Tip Cell Tip59. MS-EXCEL is based on ________ DOS OS/2 UNIX WINDOWS60. Which shortcut key is used to comment to cell F2 F3 Shift + F2 Ctrl + F261. Excel displays the current cell address in the ________ Name Box Formula bar Title Bar Status Bar62. Can we use table in excel to create filter ? Yes No63. ____________ Option is used to copy formatting from one cell to other cell . Format Painter Painter Format Cleaner Format64. You can activate a cell by All of the above Clicking the cell Pressing an arrow key Pressing the Tab key65. which shortcuty key is used to edit a cell ? Ctrl + 7 F4 F9 F266. The value of cell is displayed in Name box Formula bar View Review67. ____________ is shortcut to find and replace in ms excel. Shift + H Ctrl + F Shift + F Ctrl + H68. Which of the following is not the correct method of editing the cell content? Press the Alt key Double click the cell Press the F2 key Click the formula bar Loading …Question 1 of 68