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. What is the shortcut key to replace a data with another in sheet? Ctrl + F Ctrl + H Ctrl + R Ctrl + Shift + R2. 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 view3. To activate Microsoft excel through run command, the keyword is Excel Msexcel Winexcel microsoftexcel4. Can we use table in excel to create filter ? No Yes5. Which of the following is not a term of MS-Excel? Rows Columns Document Cells6. Which of the following is not the correct method of editing the cell content? Press the Alt key Click the formula bar Press the F2 key Double click the cell7. Which of the following is not a term of MS-Excel? Cells Document Rows Columns8. A ________ is a grid with labeled columns and rows. Toolbar Dialog box Clipboard Worksheet9. Can we use formula bar to edit formula ? Yes No10. Comments put in cells are called Smart Tip Cell Tip Web Tip Soft Tip11. Microsoft Excel is a powerful ________ Word processing package DBMS package Spreadsheet package Communication S/W Package12. Which Chart can be created in Excel? pie All of the these Area Line13. Which key do you press to check spelling? F7 F4 F12 F614. Excel displays the current cell address in the ________ Name Box Status Bar Formula bar Title Bar15. Can we use table in excel to create filter ? Yes No16. To activate Microsoft excel through run command, the keyword is Winexcel Msexcel microsoftexcel Excel17. What is the shortcut key to replace a data with another in sheet? Ctrl + F Ctrl + R Ctrl + Shift + R Ctrl + H18. 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 ell19. MS-EXCEL is based on ________ UNIX DOS WINDOWS OS/220. Excel displays the current cell address in the ________ Name Box Title Bar Status Bar Formula bar21. All of the above Date () Time () Today () Now ()22. You can activate a cell by All of the above Pressing an arrow key Clicking the cell Pressing the Tab key23. Which shortcut key is used to comment to cell Ctrl + F2 Shift + F2 F3 F224. MS-EXCEL is based on ________ UNIX WINDOWS OS/2 DOS25. Can we view gridline and heading in print preview ? Yes No26. Microsoft Excel is a powerful ________ Communication S/W Package DBMS package Word processing package Spreadsheet package27. 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 ell28. Which term is used to join the selected cells in to one cell? Wrap text Merge & Center Clear formatting wrap29. Which area in an Excel window allows entering values and formulas? Formula Bar Standard Tool Bar Menu Bar Title Bar30. Excel is a program that is used to prepare a Text document Slide presentation Database Spreadsheet31. To close MS Word which of the following method can we use Click on Close button Click on Close button Click on view Click on File tab button, then exit32. All of the above Now () Time () Date () Today ()33. Which area in an Excel window allows entering values and formulas? Standard Tool Bar Formula Bar Title Bar Menu Bar34. Which key do you press to check spelling? F4 F12 F7 F635. Comments put in cells are called Web Tip Smart Tip Cell Tip Soft Tip36. How many worksheets can we added in a workbook? 257 255 105 25637. Which shortcut key is used to comment to cell F2 Shift + F2 F3 Ctrl + F238. 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 cell39. You can activate a cell by Clicking the cell Pressing the Tab key All of the above Pressing an arrow key40. ____________ Option is used to copy formatting from one cell to other cell . Format Painter Format Format Cleaner Painter41. Which is used to perform what if analysis? Scenario Manager Data Table All of these Goal seek42. Which of the following methods are used to edit cell F2 F1 Name box Formula tab43. ____________ is shortcut to find and replace in ms excel. Shift + H Ctrl + F Shift + F Ctrl + H44. The value of cell is displayed in View Review Name box Formula bar45. How many worksheets can we added in a workbook? 255 256 105 25746. Can we use formula bar to edit formula ? Yes No47. A ________ is a grid with labeled columns and rows. Clipboard Dialog box Toolbar Worksheet48. which shortcuty key is used to edit a cell ? F4 F9 F2 Ctrl + 749. A formula in Excel always begins with an ____ Sign Plus Multiply Equal Minus50. Which Chart can be created in Excel? Area Line All of the these pie51. Which of the following methods cannot be used to enter data in a cell Pressing an arrow key Clicking on the formula bar Pressing the Tab key Pressing the Esc key52. Which term is used to join the selected cells in to one cell? Wrap text Merge & Center wrap Clear formatting53. An Excel Workbook is a collection of ________ Worksheets Charts Workbooks Worksheets and Charts54. Can we view gridline and heading in print preview ? No Yes55. The value of cell is displayed in View Review Name box Formula bar56. ____________ is shortcut to find and replace in ms excel. Ctrl + H Shift + F Shift + H Ctrl + F57. Which of the following methods are used to edit cell F1 Formula tab Name box F258. The first cell in excel worksheet is _______ AA A1 AB B159. which shortcuty key is used to edit a cell ? F2 F9 Ctrl + 7 F460. What is extension of excel 2013 ? xlsx xlx xlsm xlxs.61. ____________ Option is used to copy formatting from one cell to other cell . Format Cleaner Painter Format Format Painter62. A formula in Excel always begins with an ____ Sign Minus Plus Equal Multiply63. What is extension of excel 2013 ? xlsm xlsx xlxs. xlx64. 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 key65. The first cell in excel worksheet is _______ AB AA A1 B166. An Excel Workbook is a collection of ________ Workbooks Charts Worksheets Worksheets and Charts67. Excel is a program that is used to prepare a Text document Spreadsheet Database Slide presentation68. Which is used to perform what if analysis? Data Table Scenario Manager All of these Goal seek Loading …Question 1 of 68