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 is used to perform what if analysis? All of these Goal seek Data Table Scenario Manager2. A ________ is a grid with labeled columns and rows. Toolbar Worksheet Dialog box Clipboard3. The first cell in excel worksheet is _______ A1 B1 AA AB4. Which of the following methods are used to edit cell Name box F1 F2 Formula tab5. Excel displays the current cell address in the ________ Formula bar Status Bar Name Box Title Bar6. Which Chart can be created in Excel? pie All of the these Area Line7. Can we use formula bar to edit formula ? Yes No8. How many worksheets can we added in a workbook? 255 257 105 2569. An Excel Workbook is a collection of ________ Worksheets Worksheets and Charts Workbooks Charts10. which shortcuty key is used to edit a cell ? F4 F9 Ctrl + 7 F211. Can we use table in excel to create filter ? Yes No12. Microsoft Excel is a powerful ________ Spreadsheet package DBMS package Word processing package Communication S/W Package13. ____________ Option is used to copy formatting from one cell to other cell . Format Cleaner Format Painter Painter Format14. Which area in an Excel window allows entering values and formulas? Formula Bar Menu Bar Standard Tool Bar Title Bar15. 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 key16. Can we use table in excel to create filter ? No Yes17. Which shortcut key is used to comment to cell F3 F2 Shift + F2 Ctrl + F218. How many worksheets can we added in a workbook? 105 255 256 25719. Which of the following is not the correct method of editing the cell content? Click the formula bar Press the F2 key Press the Alt key Double click the cell20. which shortcuty key is used to edit a cell ? F2 Ctrl + 7 F9 F421. An Excel Workbook is a collection of ________ Worksheets and Charts Workbooks Worksheets Charts22. What is the shortcut key to replace a data with another in sheet? Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F23. Which of the following methods are used to edit cell F2 Formula tab Name box F124. Comments put in cells are called Cell Tip Smart Tip Soft Tip Web Tip25. 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 button26. Which Chart can be created in Excel? All of the these Area pie Line27. ____________ Option is used to copy formatting from one cell to other cell . Format Cleaner Format Painter Painter Format28. To close MS Word which of the following method can we use Click on Close button Click on Close button Click on File tab button, then exit Click on view29. The first cell in excel worksheet is _______ A1 AA B1 AB30. What is extension of excel 2013 ? xlsx xlx xlxs. xlsm31. The value of cell is displayed in Formula bar Name box View Review32. Which key do you press to check spelling? F12 F7 F6 F433. Comments put in cells are called Smart Tip Soft Tip Cell Tip Web Tip34. Which of the following is not a term of MS-Excel? Rows Cells Columns Document35. MS-EXCEL is based on ________ OS/2 UNIX DOS WINDOWS36. Can we use formula bar to edit formula ? No Yes37. A formula in Excel always begins with an ____ Sign Multiply Minus Plus Equal 38. Excel is a program that is used to prepare a Text document Spreadsheet Slide presentation Database39. Which key do you press to check spelling? F4 F12 F7 F640. Which shortcut key is used to comment to cell Shift + F2 Ctrl + F2 F3 F241. You can activate a cell by All of the above Clicking the cell Pressing an arrow key Pressing the Tab key42. Which of the following is not a term of MS-Excel? Document Columns Cells Rows43. The value of cell is displayed in View Review Name box Formula bar44. What is the shortcut key to replace a data with another in sheet? Ctrl + R Ctrl + Shift + R Ctrl + F Ctrl + H45. Which is used to perform what if analysis? Scenario Manager All of these Data Table Goal seek46. Can we view gridline and heading in print preview ? No Yes47. ____________ is shortcut to find and replace in ms excel. Ctrl + H Shift + F Ctrl + F Shift + H48. ____________ is shortcut to find and replace in ms excel. Ctrl + H Shift + H Shift + F Ctrl + F49. Which term is used to join the selected cells in to one cell? Clear formatting Merge & Center wrap Wrap text50. All of the above Date () Today () Time () Now ()51. Excel displays the current cell address in the ________ Name Box Formula bar Title Bar Status Bar52. Which option is used to join the selected cells into single cell and center the content of cell ? Unmerge ell Merge & Center Merge Cell Merge Across53. A ________ is a grid with labeled columns and rows. Worksheet Toolbar Dialog box Clipboard54. You can activate a cell by Clicking the cell Pressing the Tab key All of the above Pressing an arrow key55. Can we view gridline and heading in print preview ? No Yes56. A formula in Excel always begins with an ____ Sign Plus Equal Minus Multiply57. Which of the following methods cannot be used to enter data in a cell Pressing an arrow key Pressing the Esc key Pressing the Tab key Clicking on the formula bar58. All of the above Time () Now () Today () Date ()59. Which term is used to join the selected cells in to one cell? Merge & Center Clear formatting Wrap text wrap60. To activate Microsoft excel through run command, the keyword is microsoftexcel Winexcel Msexcel Excel61. MS-EXCEL is based on ________ DOS UNIX WINDOWS OS/262. Excel is a program that is used to prepare a Text document Slide presentation Spreadsheet Database63. Which of the following methods cannot be used to enter data in a cell Pressing an arrow key Pressing the Esc key Pressing the Tab key Clicking on the formula bar64. What is extension of excel 2013 ? xlsm xlxs. xlx xlsx65. Which area in an Excel window allows entering values and formulas? Menu Bar Standard Tool Bar Title Bar Formula Bar66. Microsoft Excel is a powerful ________ Spreadsheet package Communication S/W Package DBMS package Word processing package67. To activate Microsoft excel through run command, the keyword is Excel microsoftexcel Msexcel Winexcel68. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Cell Merge Across Merge & Center Unmerge ell Loading …Question 1 of 68