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. Excel displays the current cell address in the ________ Formula bar Title Bar Status Bar Name Box2. Which Chart can be created in Excel? pie Line All of the these Area3. Excel is a program that is used to prepare a Database Text document Slide presentation Spreadsheet4. What is extension of excel 2013 ? xlsm xlxs. xlsx xlx5. Comments put in cells are called Smart Tip Cell Tip Soft Tip Web Tip6. To activate Microsoft excel through run command, the keyword is microsoftexcel Winexcel Excel Msexcel7. Microsoft Excel is a powerful ________ DBMS package Communication S/W Package Spreadsheet package Word processing package8. MS-EXCEL is based on ________ WINDOWS OS/2 DOS UNIX9. Which term is used to join the selected cells in to one cell? Wrap text wrap Merge & Center Clear formatting10. Comments put in cells are called Web Tip Cell Tip Smart Tip Soft Tip11. You can activate a cell by All of the above Pressing the Tab key Pressing an arrow key Clicking the cell12. Can we use table in excel to create filter ? Yes No13. Can we use table in excel to create filter ? No Yes14. How many worksheets can we added in a workbook? 255 257 256 10515. How many worksheets can we added in a workbook? 105 257 256 25516. What is the shortcut key to replace a data with another in sheet? Ctrl + F Ctrl + R Ctrl + Shift + R Ctrl + H17. Which key do you press to check spelling? F4 F7 F12 F618. 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 key19. An Excel Workbook is a collection of ________ Charts Workbooks Worksheets and Charts Worksheets20. which shortcuty key is used to edit a cell ? F4 F2 F9 Ctrl + 721. Can we use formula bar to edit formula ? Yes No22. All of the above Date () Time () Now () Today ()23. Can we use formula bar to edit formula ? Yes No24. What is extension of excel 2013 ? xlsm xlsx xlx xlxs.25. ____________ Option is used to copy formatting from one cell to other cell . Format Painter Format Painter Format Cleaner26. You can activate a cell by Pressing an arrow key Clicking the cell All of the above Pressing the Tab key27. Which of the following is not the correct method of editing the cell content? Press the F2 key Double click the cell Click the formula bar Press the Alt key28. ____________ Option is used to copy formatting from one cell to other cell . Format Cleaner Format Painter Painter Format29. Which shortcut key is used to comment to cell F3 Ctrl + F2 F2 Shift + F230. The first cell in excel worksheet is _______ AA A1 B1 AB31. Which key do you press to check spelling? F7 F4 F12 F632. All of the above Today () Now () Time () Date ()33. Which of the following methods are used to edit cell Name box F1 F2 Formula tab34. Which of the following methods are used to edit cell Name box Formula tab F1 F235. 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 exit36. The first cell in excel worksheet is _______ A1 B1 AA AB37. Microsoft Excel is a powerful ________ DBMS package Communication S/W Package Word processing package Spreadsheet package38. Which shortcut key is used to comment to cell Shift + F2 F3 F2 Ctrl + F239. Which is used to perform what if analysis? Data Table Scenario Manager All of these Goal seek40. A formula in Excel always begins with an ____ Sign Equal Minus Multiply Plus 41. A formula in Excel always begins with an ____ Sign Equal Minus Multiply Plus 42. Can we view gridline and heading in print preview ? No Yes43. An Excel Workbook is a collection of ________ Charts Worksheets Worksheets and Charts Workbooks44. Which of the following is not a term of MS-Excel? Columns Document Rows Cells45. To close MS Word which of the following method can we use Click on File tab button, then exit Click on view Click on Close button Click on Close button46. What is the shortcut key to replace a data with another in sheet? Ctrl + Shift + R Ctrl + R Ctrl + H Ctrl + F47. 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 ell48. Which area in an Excel window allows entering values and formulas? Formula Bar Menu Bar Title Bar Standard Tool Bar49. ____________ is shortcut to find and replace in ms excel. Ctrl + H Ctrl + F Shift + H Shift + F50. Excel is a program that is used to prepare a Text document Slide presentation Database Spreadsheet51. Which Chart can be created in Excel? Line pie Area All of the these52. 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 Cell53. The value of cell is displayed in Review View Formula bar Name box54. Excel displays the current cell address in the ________ Title Bar Status Bar Name Box Formula bar55. Can we view gridline and heading in print preview ? Yes No56. MS-EXCEL is based on ________ DOS UNIX OS/2 WINDOWS57. A ________ is a grid with labeled columns and rows. Dialog box Toolbar Clipboard Worksheet58. Which is used to perform what if analysis? Scenario Manager Data Table Goal seek All of these59. which shortcuty key is used to edit a cell ? Ctrl + 7 F9 F4 F260. Which area in an Excel window allows entering values and formulas? Menu Bar Title Bar Formula Bar Standard Tool Bar61. Which of the following is not a term of MS-Excel? Cells Columns Rows Document62. ____________ is shortcut to find and replace in ms excel. Ctrl + F Shift + H Shift + F Ctrl + H63. Which of the following methods cannot be used to enter data in a cell Pressing the Esc key Pressing the Tab key Clicking on the formula bar Pressing an arrow key64. Which of the following is not the correct method of editing the cell content? Press the F2 key Press the Alt key Click the formula bar Double click the cell65. The value of cell is displayed in Formula bar Name box View Review66. Which term is used to join the selected cells in to one cell? wrap Wrap text Clear formatting Merge & Center67. A ________ is a grid with labeled columns and rows. Toolbar Worksheet Clipboard Dialog box68. To activate Microsoft excel through run command, the keyword is Msexcel Excel microsoftexcel Winexcel Loading …Question 1 of 68