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. The value of cell is displayed in Review View Formula bar Name box2. Which of the following methods are used to edit cell F1 Name box Formula tab F23. ____________ is shortcut to find and replace in ms excel. Ctrl + F Shift + F Ctrl + H Shift + H4. How many worksheets can we added in a workbook? 257 256 105 2555. Excel displays the current cell address in the ________ Formula bar Title Bar Name Box Status Bar6. 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 key7. ____________ is shortcut to find and replace in ms excel. Ctrl + H Ctrl + F Shift + F Shift + H8. Can we view gridline and heading in print preview ? No Yes9. MS-EXCEL is based on ________ OS/2 WINDOWS DOS UNIX10. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Cell Unmerge ell Merge Across Merge & Center11. Microsoft Excel is a powerful ________ Communication S/W Package DBMS package Word processing package Spreadsheet package12. Which area in an Excel window allows entering values and formulas? Formula Bar Menu Bar Title Bar Standard Tool Bar13. You can activate a cell by Pressing the Tab key Pressing an arrow key Clicking the cell All of the above14. Which key do you press to check spelling? F7 F12 F6 F415. An Excel Workbook is a collection of ________ Worksheets Workbooks Charts Worksheets and Charts16. Which of the following is not a term of MS-Excel? Cells Document Columns Rows17. Excel displays the current cell address in the ________ Formula bar Name Box Title Bar Status Bar18. Excel is a program that is used to prepare a Text document Slide presentation Spreadsheet Database19. A formula in Excel always begins with an ____ Sign Minus Multiply Equal Plus 20. which shortcuty key is used to edit a cell ? Ctrl + 7 F4 F2 F921. An Excel Workbook is a collection of ________ Workbooks Worksheets and Charts Worksheets Charts22. The first cell in excel worksheet is _______ B1 AB AA A123. ____________ Option is used to copy formatting from one cell to other cell . Format Format Cleaner Format Painter Painter24. How many worksheets can we added in a workbook? 257 105 255 25625. What is the shortcut key to replace a data with another in sheet? Ctrl + F Ctrl + H Ctrl + Shift + R Ctrl + R26. Which Chart can be created in Excel? Area pie Line All of the these27. Can we use formula bar to edit formula ? No Yes28. Microsoft Excel is a powerful ________ Word processing package Communication S/W Package DBMS package Spreadsheet package29. 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 key30. Can we view gridline and heading in print preview ? No Yes31. The value of cell is displayed in Name box View Review Formula bar32. Which of the following is not the correct method of editing the cell content? Double click the cell Press the Alt key Click the formula bar Press the F2 key33. Can we use table in excel to create filter ? No Yes34. Which term is used to join the selected cells in to one cell? Wrap text Clear formatting wrap Merge & Center35. Which shortcut key is used to comment to cell Ctrl + F2 F2 F3 Shift + F236. Which option is used to join the selected cells into single cell and center the content of cell ? Merge & Center Unmerge ell Merge Cell Merge Across37. Which is used to perform what if analysis? All of these Goal seek Scenario Manager Data Table38. To activate Microsoft excel through run command, the keyword is Excel Winexcel microsoftexcel Msexcel39. What is extension of excel 2013 ? xlsm xlxs. xlsx xlx40. To activate Microsoft excel through run command, the keyword is Excel Winexcel microsoftexcel Msexcel41. Comments put in cells are called Smart Tip Soft Tip Web Tip Cell Tip42. Can we use table in excel to create filter ? No Yes43. Which Chart can be created in Excel? All of the these pie Area Line44. 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 button45. Comments put in cells are called Soft Tip Smart Tip Cell Tip Web Tip46. Which of the following methods cannot be used to enter data in a cell Pressing an arrow key Pressing the Esc key Clicking on the formula bar Pressing the Tab key47. Which key do you press to check spelling? F12 F6 F7 F448. All of the above Time () Today () Date () Now ()49. 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 view50. MS-EXCEL is based on ________ DOS UNIX WINDOWS OS/251. Which shortcut key is used to comment to cell Ctrl + F2 F2 F3 Shift + F252. Excel is a program that is used to prepare a Slide presentation Text document Database Spreadsheet53. Which term is used to join the selected cells in to one cell? wrap Clear formatting Wrap text Merge & Center54. A ________ is a grid with labeled columns and rows. Dialog box Clipboard Worksheet Toolbar55. Can we use formula bar to edit formula ? Yes No56. You can activate a cell by Pressing an arrow key Clicking the cell Pressing the Tab key All of the above57. All of the above Today () Date () Now () Time ()58. A ________ is a grid with labeled columns and rows. Clipboard Worksheet Toolbar Dialog box59. Which of the following is not a term of MS-Excel? Cells Rows Columns Document60. What is extension of excel 2013 ? xlx xlsx xlxs. xlsm61. What is the shortcut key to replace a data with another in sheet? Ctrl + H Ctrl + F Ctrl + Shift + R Ctrl + R62. The first cell in excel worksheet is _______ AA B1 A1 AB63. Which area in an Excel window allows entering values and formulas? Title Bar Menu Bar Standard Tool Bar Formula Bar64. ____________ Option is used to copy formatting from one cell to other cell . Format Painter Format Cleaner Format Painter65. Which is used to perform what if analysis? Data Table All of these Scenario Manager Goal seek66. A formula in Excel always begins with an ____ Sign Equal Multiply Plus Minus67. which shortcuty key is used to edit a cell ? F2 F9 Ctrl + 7 F468. Which of the following methods are used to edit cell Name box Formula tab F2 F1 Loading …Question 1 of 68