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. MS-EXCEL is based on ________ WINDOWS UNIX DOS OS/22. Can we use table in excel to create filter ? Yes No3. Excel is a program that is used to prepare a Database Spreadsheet Slide presentation Text document4. Which is used to perform what if analysis? Goal seek All of these Scenario Manager Data Table5. Can we view gridline and heading in print preview ? No Yes6. A formula in Excel always begins with an ____ Sign Multiply Plus Equal Minus7. To activate Microsoft excel through run command, the keyword is Winexcel microsoftexcel Excel Msexcel8. Which of the following is not a term of MS-Excel? Columns Rows Cells Document9. How many worksheets can we added in a workbook? 105 256 257 25510. All of the above Now () Date () Today () Time ()11. You can activate a cell by Clicking the cell Pressing the Tab key Pressing an arrow key All of the above12. The value of cell is displayed in View Formula bar Name box Review13. Can we view gridline and heading in print preview ? Yes No14. Which shortcut key is used to comment to cell Shift + F2 F2 Ctrl + F2 F315. Which key do you press to check spelling? F6 F12 F7 F416. How many worksheets can we added in a workbook? 257 255 105 25617. A ________ is a grid with labeled columns and rows. Toolbar Dialog box Worksheet Clipboard18. What is the shortcut key to replace a data with another in sheet? Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F19. Which of the following methods are used to edit cell Name box Formula tab F1 F220. An Excel Workbook is a collection of ________ Worksheets Charts Workbooks Worksheets and Charts21. What is extension of excel 2013 ? xlxs. xlx xlsm xlsx22. Can we use formula bar to edit formula ? Yes No23. Which is used to perform what if analysis? Data Table Scenario Manager All of these Goal seek24. Microsoft Excel is a powerful ________ DBMS package Spreadsheet package Communication S/W Package Word processing package25. A ________ is a grid with labeled columns and rows. Dialog box Clipboard Toolbar Worksheet26. Which of the following is not the correct method of editing the cell content? Press the F2 key Click the formula bar Double click the cell Press the Alt key27. Which term is used to join the selected cells in to one cell? Merge & Center Wrap text wrap Clear formatting28. MS-EXCEL is based on ________ OS/2 UNIX DOS WINDOWS29. which shortcuty key is used to edit a cell ? F4 F9 F2 Ctrl + 730. You can activate a cell by Pressing the Tab key Clicking the cell All of the above Pressing an arrow key31. 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 bar32. 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 cell33. Which of the following methods cannot be used to enter data in a cell Pressing the Tab key Pressing the Esc key Clicking on the formula bar Pressing an arrow key34. 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 view35. Microsoft Excel is a powerful ________ Spreadsheet package Communication S/W Package Word processing package DBMS package36. All of the above Date () Today () Now () Time ()37. What is the shortcut key to replace a data with another in sheet? Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F38. Excel displays the current cell address in the ________ Status Bar Name Box Formula bar Title Bar39. To activate Microsoft excel through run command, the keyword is Winexcel microsoftexcel Msexcel Excel40. ____________ is shortcut to find and replace in ms excel. Shift + H Shift + F Ctrl + F Ctrl + H41. To close MS Word which of the following method can we use Click on view Click on Close button Click on File tab button, then exit Click on Close button42. which shortcuty key is used to edit a cell ? F9 Ctrl + 7 F4 F243. Which of the following methods are used to edit cell F1 F2 Name box Formula tab44. Which area in an Excel window allows entering values and formulas? Standard Tool Bar Formula Bar Menu Bar Title Bar45. What is extension of excel 2013 ? xlsm xlsx xlx xlxs.46. Which area in an Excel window allows entering values and formulas? Title Bar Formula Bar Menu Bar Standard Tool Bar47. Which key do you press to check spelling? F7 F6 F12 F448. ____________ is shortcut to find and replace in ms excel. Shift + H Shift + F Ctrl + H Ctrl + F49. Which Chart can be created in Excel? All of the these pie Area Line50. Which shortcut key is used to comment to cell Shift + F2 F3 Ctrl + F2 F251. Excel displays the current cell address in the ________ Name Box Status Bar Formula bar Title Bar52. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Cell Merge & Center Merge Across Unmerge ell53. Can we use formula bar to edit formula ? No Yes54. The first cell in excel worksheet is _______ B1 AB AA A155. An Excel Workbook is a collection of ________ Charts Workbooks Worksheets Worksheets and Charts56. Which of the following is not a term of MS-Excel? Document Cells Rows Columns57. The value of cell is displayed in View Name box Formula bar Review58. 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 Cell59. The first cell in excel worksheet is _______ B1 AB AA A160. Comments put in cells are called Cell Tip Smart Tip Soft Tip Web Tip61. ____________ Option is used to copy formatting from one cell to other cell . Format Format Cleaner Painter Format Painter62. Excel is a program that is used to prepare a Spreadsheet Slide presentation Text document Database63. ____________ Option is used to copy formatting from one cell to other cell . Painter Format Format Painter Format Cleaner64. Which Chart can be created in Excel? Line Area pie All of the these65. A formula in Excel always begins with an ____ Sign Minus Multiply Plus Equal 66. Which term is used to join the selected cells in to one cell? Merge & Center Wrap text wrap Clear formatting67. Comments put in cells are called Soft Tip Cell Tip Smart Tip Web Tip68. Can we use table in excel to create filter ? Yes No Loading …Question 1 of 68