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 Chart can be created in Excel? Area All of the these Line pie2. MS-EXCEL is based on ________ DOS OS/2 WINDOWS UNIX3. 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 exit4. Which shortcut key is used to comment to cell F3 Shift + F2 F2 Ctrl + F25. The first cell in excel worksheet is _______ AB AA B1 A16. A formula in Excel always begins with an ____ Sign Equal Minus Multiply Plus 7. MS-EXCEL is based on ________ OS/2 DOS UNIX WINDOWS8. How many worksheets can we added in a workbook? 256 255 257 1059. How many worksheets can we added in a workbook? 257 105 255 25610. All of the above Date () Now () Time () Today ()11. which shortcuty key is used to edit a cell ? Ctrl + 7 F4 F9 F212. You can activate a cell by Pressing the Tab key Clicking the cell All of the above Pressing an arrow key13. Which of the following is not the correct method of editing the cell content? Press the F2 key Click the formula bar Press the Alt key Double click the cell14. Can we view gridline and heading in print preview ? Yes No15. Which Chart can be created in Excel? Line All of the these pie Area16. To activate Microsoft excel through run command, the keyword is Msexcel Winexcel microsoftexcel Excel17. which shortcuty key is used to edit a cell ? F2 Ctrl + 7 F9 F418. Which of the following is not a term of MS-Excel? Rows Cells Document Columns19. ____________ Option is used to copy formatting from one cell to other cell . Painter Format Format Painter Format Cleaner20. The first cell in excel worksheet is _______ A1 AA AB B121. Which of the following methods are used to edit cell F2 Name box Formula tab F122. Which shortcut key is used to comment to cell Ctrl + F2 Shift + F2 F2 F323. Comments put in cells are called Smart Tip Soft Tip Web Tip Cell Tip24. ____________ Option is used to copy formatting from one cell to other cell . Format Format Cleaner Format Painter Painter25. The value of cell is displayed in Formula bar View Name box Review26. Which is used to perform what if analysis? Scenario Manager Data Table Goal seek All of these27. A formula in Excel always begins with an ____ Sign Equal Plus Minus Multiply28. Which option is used to join the selected cells into single cell and center the content of cell ? Merge & Center Unmerge ell Merge Cell Merge Across29. You can activate a cell by Pressing the Tab key All of the above Pressing an arrow key Clicking the cell30. A ________ is a grid with labeled columns and rows. Clipboard Dialog box Worksheet Toolbar31. Excel is a program that is used to prepare a Database Spreadsheet Text document Slide presentation32. What is extension of excel 2013 ? xlxs. xlsx xlx xlsm33. Which area in an Excel window allows entering values and formulas? Standard Tool Bar Title Bar Formula Bar Menu Bar34. Can we use formula bar to edit formula ? Yes No35. 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 key36. What is the shortcut key to replace a data with another in sheet? Ctrl + H Ctrl + R Ctrl + F Ctrl + Shift + R37. Excel is a program that is used to prepare a Text document Spreadsheet Slide presentation Database38. Comments put in cells are called Soft Tip Web Tip Smart Tip Cell Tip39. Which of the following methods cannot be used to enter data in a cell Clicking on the formula bar Pressing the Esc key Pressing the Tab key Pressing an arrow key40. What is the shortcut key to replace a data with another in sheet? Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H41. Which of the following is not a term of MS-Excel? Rows Document Cells Columns42. Excel displays the current cell address in the ________ Status Bar Formula bar Name Box Title Bar43. Which of the following methods are used to edit cell F2 Formula tab F1 Name box44. Microsoft Excel is a powerful ________ DBMS package Word processing package Spreadsheet package Communication S/W Package45. Microsoft Excel is a powerful ________ DBMS package Spreadsheet package Word processing package Communication S/W Package46. ____________ is shortcut to find and replace in ms excel. Shift + F Ctrl + F Shift + H Ctrl + H47. Which term is used to join the selected cells in to one cell? wrap Wrap text Merge & Center Clear formatting48. 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 ell49. A ________ is a grid with labeled columns and rows. Dialog box Worksheet Toolbar Clipboard50. Can we use formula bar to edit formula ? Yes No51. ____________ is shortcut to find and replace in ms excel. Shift + F Ctrl + H Shift + H Ctrl + F52. Can we use table in excel to create filter ? No Yes53. The value of cell is displayed in View Name box Formula bar Review54. Which is used to perform what if analysis? Data Table All of these Goal seek Scenario Manager55. To activate Microsoft excel through run command, the keyword is microsoftexcel Msexcel Winexcel Excel56. 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 bar57. An Excel Workbook is a collection of ________ Worksheets and Charts Workbooks Charts Worksheets58. Which key do you press to check spelling? F6 F4 F12 F759. All of the above Time () Today () Date () Now ()60. Can we view gridline and heading in print preview ? No Yes61. Which key do you press to check spelling? F4 F7 F12 F662. Which area in an Excel window allows entering values and formulas? Formula Bar Standard Tool Bar Menu Bar Title Bar63. What is extension of excel 2013 ? xlsm xlsx xlxs. xlx64. Can we use table in excel to create filter ? Yes No65. Which term is used to join the selected cells in to one cell? wrap Merge & Center Clear formatting Wrap text66. An Excel Workbook is a collection of ________ Worksheets Charts Worksheets and Charts Workbooks67. 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 view68. Excel displays the current cell address in the ________ Formula bar Status Bar Title Bar Name Box Loading …Question 1 of 68