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. You can activate a cell by Clicking the cell Pressing an arrow key Pressing the Tab key All of the above2. Excel is a program that is used to prepare a Slide presentation Text document Spreadsheet Database3. Which is used to perform what if analysis? All of these Scenario Manager Goal seek Data Table4. An Excel Workbook is a collection of ________ Worksheets and Charts Worksheets Workbooks Charts5. which shortcuty key is used to edit a cell ? Ctrl + 7 F9 F2 F46. Which of the following is not a term of MS-Excel? Cells Document Rows Columns7. What is the shortcut key to replace a data with another in sheet? Ctrl + Shift + R Ctrl + F Ctrl + R Ctrl + H8. A formula in Excel always begins with an ____ Sign Minus Plus Equal Multiply9. ____________ Option is used to copy formatting from one cell to other cell . Format Format Cleaner Format Painter Painter10. An Excel Workbook is a collection of ________ Worksheets Charts Worksheets and Charts Workbooks11. How many worksheets can we added in a workbook? 255 257 105 25612. Which term is used to join the selected cells in to one cell? Merge & Center wrap Wrap text Clear formatting13. 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 exit14. Which Chart can be created in Excel? All of the these pie Line Area15. You can activate a cell by All of the above Pressing the Tab key Pressing an arrow key Clicking the cell16. Microsoft Excel is a powerful ________ DBMS package Spreadsheet package Word processing package Communication S/W Package17. Which of the following methods cannot be used to enter data in a cell Clicking on the formula bar Pressing the Tab key Pressing the Esc key Pressing an arrow key18. What is extension of excel 2013 ? xlsm xlx xlsx xlxs.19. Excel is a program that is used to prepare a Text document Slide presentation Database Spreadsheet20. The first cell in excel worksheet is _______ AB AA A1 B121. Which shortcut key is used to comment to cell F2 F3 Ctrl + F2 Shift + F222. Excel displays the current cell address in the ________ Name Box Formula bar Status Bar Title Bar23. Which Chart can be created in Excel? All of the these Line Area pie24. Which term is used to join the selected cells in to one cell? wrap Merge & Center Clear formatting Wrap text25. Excel displays the current cell address in the ________ Formula bar Status Bar Name Box Title Bar26. Comments put in cells are called Cell Tip Soft Tip Smart Tip Web Tip27. Can we use formula bar to edit formula ? Yes No28. Which area in an Excel window allows entering values and formulas? Formula Bar Title Bar Standard Tool Bar Menu Bar29. How many worksheets can we added in a workbook? 256 255 105 25730. All of the above Today () Date () Time () Now ()31. Which shortcut key is used to comment to cell F3 Shift + F2 F2 Ctrl + F232. Which area in an Excel window allows entering values and formulas? Formula Bar Menu Bar Title Bar Standard Tool Bar33. ____________ is shortcut to find and replace in ms excel. Ctrl + F Ctrl + H Shift + F Shift + H34. Which of the following is not a term of MS-Excel? Document Cells Rows Columns35. A ________ is a grid with labeled columns and rows. Toolbar Clipboard Dialog box Worksheet36. Which of the following methods cannot be used to enter data in a cell Pressing the Esc key Pressing an arrow key Pressing the Tab key Clicking on the formula bar37. Comments put in cells are called Smart Tip Soft Tip Web Tip Cell Tip38. What is the shortcut key to replace a data with another in sheet? Ctrl + F Ctrl + R Ctrl + Shift + R Ctrl + H39. Which option is used to join the selected cells into single cell and center the content of cell ? Merge & Center Unmerge ell Merge Across Merge Cell40. Can we use table in excel to create filter ? Yes No41. What is extension of excel 2013 ? xlsx xlsm xlxs. xlx42. ____________ Option is used to copy formatting from one cell to other cell . Format Painter Format Cleaner Format Painter43. Which option is used to join the selected cells into single cell and center the content of cell ? Unmerge ell Merge Across Merge Cell Merge & Center44. The value of cell is displayed in Review Name box View Formula bar45. ____________ is shortcut to find and replace in ms excel. Shift + F Ctrl + F Ctrl + H Shift + H46. A formula in Excel always begins with an ____ Sign Plus Equal Multiply Minus47. Which key do you press to check spelling? F4 F12 F6 F748. Which is used to perform what if analysis? Scenario Manager All of these Goal seek Data Table49. Can we use formula bar to edit formula ? Yes No50. Which of the following methods are used to edit cell F2 F1 Formula tab Name box51. Which of the following is not the correct method of editing the cell content? Press the F2 key Press the Alt key Double click the cell Click the formula bar52. Which key do you press to check spelling? F7 F6 F12 F453. A ________ is a grid with labeled columns and rows. Worksheet Clipboard Toolbar Dialog box54. Which of the following methods are used to edit cell F2 Name box F1 Formula tab55. To activate Microsoft excel through run command, the keyword is Winexcel Msexcel Excel microsoftexcel56. MS-EXCEL is based on ________ UNIX DOS WINDOWS OS/257. 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 exit58. The value of cell is displayed in Review View Formula bar Name box59. The first cell in excel worksheet is _______ AA A1 AB B160. To activate Microsoft excel through run command, the keyword is Excel Winexcel microsoftexcel Msexcel61. Can we use table in excel to create filter ? No Yes62. All of the above Now () Today () Date () Time ()63. Can we view gridline and heading in print preview ? No Yes64. which shortcuty key is used to edit a cell ? F4 F9 F2 Ctrl + 765. 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 cell66. Microsoft Excel is a powerful ________ DBMS package Communication S/W Package Word processing package Spreadsheet package67. MS-EXCEL is based on ________ WINDOWS DOS OS/2 UNIX68. Can we view gridline and heading in print preview ? No Yes Loading …Question 1 of 68