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 of the following methods are used to edit cell F2 Formula tab F1 Name box2. Microsoft Excel is a powerful ________ DBMS package Communication S/W Package Word processing package Spreadsheet package3. All of the above Now () Time () Date () Today ()4. Which term is used to join the selected cells in to one cell? Clear formatting Merge & Center Wrap text wrap5. To close MS Word which of the following method can we use Click on File tab button, then exit Click on Close button Click on Close button Click on view6. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Across Merge Cell Unmerge ell Merge & Center7. A formula in Excel always begins with an ____ Sign Equal Minus Plus Multiply8. ____________ is shortcut to find and replace in ms excel. Ctrl + H Shift + F Shift + H Ctrl + F9. Excel displays the current cell address in the ________ Name Box Status Bar Title Bar Formula bar10. Which area in an Excel window allows entering values and formulas? Formula Bar Title Bar Menu Bar Standard Tool Bar11. An Excel Workbook is a collection of ________ Worksheets Workbooks Charts Worksheets and Charts12. What is extension of excel 2013 ? xlx xlsx xlsm xlxs.13. You can activate a cell by All of the above Pressing an arrow key Pressing the Tab key Clicking the cell14. Can we use formula bar to edit formula ? Yes No15. Which of the following methods are used to edit cell F2 Formula tab Name box F116. Can we use table in excel to create filter ? No Yes17. Can we use formula bar to edit formula ? Yes No18. Which shortcut key is used to comment to cell F2 F3 Ctrl + F2 Shift + F219. MS-EXCEL is based on ________ OS/2 UNIX DOS WINDOWS20. The value of cell is displayed in Name box Review View Formula bar21. Which area in an Excel window allows entering values and formulas? Standard Tool Bar Formula Bar Title Bar Menu Bar22. ____________ Option is used to copy formatting from one cell to other cell . Painter Format Cleaner Format Format Painter23. Which key do you press to check spelling? F7 F4 F12 F624. Can we view gridline and heading in print preview ? Yes No25. Which of the following is not a term of MS-Excel? Columns Document Rows Cells26. How many worksheets can we added in a workbook? 105 255 257 25627. Comments put in cells are called Cell Tip Smart Tip Soft Tip Web Tip28. Which of the following is not the correct method of editing the cell content? Double click the cell Press the F2 key Click the formula bar Press the Alt key29. How many worksheets can we added in a workbook? 257 255 105 25630. The first cell in excel worksheet is _______ B1 AB A1 AA31. The first cell in excel worksheet is _______ AA AB A1 B132. All of the above Today () Date () Time () Now ()33. which shortcuty key is used to edit a cell ? Ctrl + 7 F4 F2 F934. What is extension of excel 2013 ? xlx xlsm xlsx xlxs.35. The value of cell is displayed in View Review Name box Formula bar36. A formula in Excel always begins with an ____ Sign Minus Multiply Plus Equal 37. Which is used to perform what if analysis? All of these Scenario Manager Goal seek Data Table38. Which of the following is not a term of MS-Excel? Rows Document Cells Columns39. An Excel Workbook is a collection of ________ Workbooks Worksheets and Charts Charts Worksheets40. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Across Merge Cell Merge & Center Unmerge ell41. Microsoft Excel is a powerful ________ DBMS package Spreadsheet package Word processing package Communication S/W Package42. Excel is a program that is used to prepare a Slide presentation Spreadsheet Database Text document43. What is the shortcut key to replace a data with another in sheet? Ctrl + H Ctrl + F Ctrl + R Ctrl + Shift + R44. Which is used to perform what if analysis? Data Table All of these Goal seek Scenario Manager45. Which Chart can be created in Excel? pie Area Line All of the these46. Which term is used to join the selected cells in to one cell? Wrap text Merge & Center wrap Clear formatting47. Which shortcut key is used to comment to cell F2 F3 Ctrl + F2 Shift + F248. What is the shortcut key to replace a data with another in sheet? Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F49. Which key do you press to check spelling? F6 F4 F7 F1250. ____________ Option is used to copy formatting from one cell to other cell . Format Painter Format Cleaner Painter Format51. Excel is a program that is used to prepare a Text document Spreadsheet Database Slide presentation52. You can activate a cell by Pressing an arrow key Clicking the cell All of the above Pressing the Tab key53. Which of the following methods cannot be used to enter data in a cell Pressing the Esc key Clicking on the formula bar Pressing the Tab key Pressing an arrow key54. Excel displays the current cell address in the ________ Title Bar Name Box Formula bar Status Bar55. Which of the following is not the correct method of editing the cell content? Click the formula bar Press the Alt key Press the F2 key Double click the cell56. Can we use table in excel to create filter ? Yes No57. MS-EXCEL is based on ________ OS/2 DOS WINDOWS UNIX58. A ________ is a grid with labeled columns and rows. Dialog box Clipboard Toolbar Worksheet59. To activate Microsoft excel through run command, the keyword is Excel Winexcel Msexcel microsoftexcel60. ____________ is shortcut to find and replace in ms excel. Ctrl + H Shift + F Shift + H Ctrl + F61. Which Chart can be created in Excel? Area pie All of the these Line62. To activate Microsoft excel through run command, the keyword is Winexcel microsoftexcel Msexcel Excel63. Which of the following methods cannot be used to enter data in a cell Clicking on the formula bar Pressing the Esc key Pressing an arrow key Pressing the Tab key64. Can we view gridline and heading in print preview ? No Yes65. 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 button66. A ________ is a grid with labeled columns and rows. Worksheet Dialog box Toolbar Clipboard67. Comments put in cells are called Soft Tip Web Tip Smart Tip Cell Tip68. which shortcuty key is used to edit a cell ? Ctrl + 7 F9 F2 F4 Loading …Question 1 of 68