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. ____________ is shortcut to find and replace in ms excel. Shift + H Shift + F Ctrl + F Ctrl + H2. All of the above Today () Time () Date () Now ()3. Which Chart can be created in Excel? pie Line All of the these Area4. Which of the following is not a term of MS-Excel? Document Cells Columns Rows5. ____________ is shortcut to find and replace in ms excel. Shift + F Ctrl + F Shift + H Ctrl + H6. MS-EXCEL is based on ________ DOS OS/2 UNIX WINDOWS7. Which is used to perform what if analysis? Scenario Manager Goal seek All of these Data Table8. Which is used to perform what if analysis? Goal seek Data Table Scenario Manager All of these9. All of the above Today () Time () Date () Now ()10. Which Chart can be created in Excel? Line pie All of the these Area11. Which area in an Excel window allows entering values and formulas? Formula Bar Standard Tool Bar Title Bar Menu Bar12. 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 key13. Which term is used to join the selected cells in to one cell? Merge & Center Wrap text wrap Clear formatting14. What is extension of excel 2013 ? xlx xlsx xlxs. xlsm15. which shortcuty key is used to edit a cell ? F9 Ctrl + 7 F2 F416. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Across Unmerge ell Merge & Center Merge Cell17. MS-EXCEL is based on ________ UNIX WINDOWS DOS OS/218. Which key do you press to check spelling? F4 F7 F6 F1219. An Excel Workbook is a collection of ________ Charts Worksheets and Charts Worksheets Workbooks20. A formula in Excel always begins with an ____ Sign Multiply Equal Minus Plus 21. The value of cell is displayed in Name box Formula bar Review View22. ____________ Option is used to copy formatting from one cell to other cell . Painter Format Painter Format Format Cleaner23. How many worksheets can we added in a workbook? 256 257 105 25524. To activate Microsoft excel through run command, the keyword is Msexcel microsoftexcel Excel Winexcel25. You can activate a cell by All of the above Pressing the Tab key Pressing an arrow key Clicking the cell26. What is the shortcut key to replace a data with another in sheet? Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F27. A ________ is a grid with labeled columns and rows. Worksheet Toolbar Clipboard Dialog box28. The value of cell is displayed in Formula bar View Review Name box29. The first cell in excel worksheet is _______ AA A1 B1 AB30. Which area in an Excel window allows entering values and formulas? Standard Tool Bar Title Bar Menu Bar Formula Bar31. Which shortcut key is used to comment to cell Ctrl + F2 Shift + F2 F3 F232. Can we view gridline and heading in print preview ? No Yes33. A formula in Excel always begins with an ____ Sign Multiply Plus Equal Minus34. What is extension of excel 2013 ? xlx xlsm xlsx xlxs.35. You can activate a cell by Pressing an arrow key Clicking the cell All of the above Pressing the Tab key36. Can we use formula bar to edit formula ? No Yes37. Excel is a program that is used to prepare a Text document Spreadsheet Database Slide presentation38. Which shortcut key is used to comment to cell Ctrl + F2 F3 Shift + F2 F239. Excel displays the current cell address in the ________ Title Bar Formula bar Status Bar Name Box40. Excel displays the current cell address in the ________ Status Bar Name Box Formula bar Title Bar41. The first cell in excel worksheet is _______ AA A1 B1 AB42. Which option is used to join the selected cells into single cell and center the content of cell ? Merge & Center Merge Across Unmerge ell Merge Cell43. How many worksheets can we added in a workbook? 257 105 256 25544. What is the shortcut key to replace a data with another in sheet? Ctrl + H Ctrl + F Ctrl + R Ctrl + Shift + R45. Which of the following is not a term of MS-Excel? Rows Cells Document Columns46. Which of the following methods cannot be used to enter data in a cell Clicking on the formula bar Pressing an arrow key Pressing the Tab key Pressing the Esc key47. Which key do you press to check spelling? F4 F12 F6 F748. Which of the following is not the correct method of editing the cell content? Press the Alt key Double click the cell Click the formula bar Press the F2 key49. To activate Microsoft excel through run command, the keyword is Excel Msexcel microsoftexcel Winexcel50. ____________ Option is used to copy formatting from one cell to other cell . Format Format Cleaner Format Painter Painter51. Can we use formula bar to edit formula ? No Yes52. Which term is used to join the selected cells in to one cell? Wrap text Merge & Center wrap Clear formatting53. Can we use table in excel to create filter ? Yes No54. Comments put in cells are called Smart Tip Web Tip Cell Tip Soft Tip55. which shortcuty key is used to edit a cell ? F9 F2 Ctrl + 7 F456. 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 key57. Excel is a program that is used to prepare a Text document Slide presentation Spreadsheet Database58. Can we view gridline and heading in print preview ? Yes No59. Microsoft Excel is a powerful ________ Word processing package Communication S/W Package DBMS package Spreadsheet package60. 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 view61. Which of the following methods are used to edit cell F2 Name box F1 Formula tab62. Comments put in cells are called Soft Tip Cell Tip Smart Tip Web Tip63. An Excel Workbook is a collection of ________ Worksheets and Charts Worksheets Charts Workbooks64. A ________ is a grid with labeled columns and rows. Worksheet Dialog box Toolbar Clipboard65. Can we use table in excel to create filter ? Yes No66. Which of the following methods are used to edit cell F2 Formula tab F1 Name box67. Microsoft Excel is a powerful ________ Communication S/W Package DBMS package Spreadsheet package Word processing package68. 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 button Loading …Question 1 of 68