MS Excel Practice Session 3Basic 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 stands for ___________ Microsoft Excel Micromax Excel Management Excel Microsoft Excess2. In Microsoft Excel spreadsheets, COLUMNS are labelled as _______ A,B,C,…. A1,B1,C1…. 1,2,3,….. I,II,III,…..3. In MS Excel, keyboard shortcut keys to create a new workbook is _____ Alt + N Ctrl + W Shift + N Ctrl + N4. Which of the following methods can be used to edit the contents of a cell? Press the Alt key Clicking the formula bar Pressing the F2 key Double clicking the cell5. Excel files have a extension ___________ xlsx txt xlm doc6. You can edit a cell by Selecting Edit > Edit Cell from the menu Clicking the formula button Double clicking the cell to edit it in-place Using Name Box7. Comments can be added to cells using Review > Comments Edit > Comments Insert > Comments File > Comments8. A ________ is a grid with labeled columns and rows. Dialog box Clipboard Toolbar Worksheet9. In a worksheet you can select All of these Columns Rows The entire worksheet10. To view a cell comment Click the edit comment command on the insert menu Click the comment command on the view menu Click the display comment command on the window menu Position the mouse pointer over the cell11. Which of the following options is not located in the Page Setup dialog box? Margins Headers and Footers Page Break Preview Page Orientation12. MS Excel is a ________ Spreadsheet software Workbook software Presentation software Database Management software13. Which of the following methods can not be used to edit the contents of a cell? Double clicking the cell Press the Alt key Clicking the formula bar Pressing the F2 key14. ___________ is a collection of cells organized in rows and columns where you keep and manipulate the data. Workbook ARRAY Worksheet Spreadsheet15. Which of the following is the latest version of Excel Excel 2010 Excel 2019 Excel 2007 Excel 201616. The name box Appears below the status bar Appears below the menu bar Appears to the right of the formula bar Shows the location of the active cell17. How many worksheets can we added in a workbook? 256 257 105 25518. The first cell in excel worksheet is _______ B1 AB A1 AA19. Excel displays the current cell address in the ________ Name Box Formula bar Status Bar Title Bar20. A typical worksheet has ________ number of columns 16348 16844 16384 1684321. Comments can be edited using _____ File > Comments Review > Comments Insert > Comments Edit > Comments22. Which of the following is not a term of MS-Excel? Rows Document Columns Cells23. Which menu option can be used to split windows into two View > window > split View > split Window > split Format > window24. Which of the following methods cannot be used to enter data in a cell Pressing the Esc key Pressing the Tab key Clicking on the formula bar Pressing an arrow key25. In Microsoft Excel spreadsheets, CELLS are labelled as _______ I,II,III,….. A,B,C,…. A1,B1,C1…. 1,2,3,…..26. Which area in an excel window allows entering values and formulas Menu bar Name Box Title bar Formula bar27. You can activate a cell by All of the above Pressing an arrow key Pressing the Tab key Clicking the cell28. Which is used to perform what if analysis? Data Table Scenario Manager All of these Goal seek29. The intersection of a column and a row in MS Excel worksheet is known as _______ Cell Tab Columns Rows30. Which symbol must all formula begin with? + = @ #31. Comments put in cells are called Smart Tip Web Tip Soft Tip Cell Tip32. Which key do you press to check spelling? F6 F7 F12 F433. In Microsoft Excel spreadsheets, rows are labelled as _______ A1,B1,C1…. I,II,III,….. 1,2,3,….. A,B,C,….34. A typical worksheet has ________ number of rows 1048576 1048567 1048577 1047859 Loading …Question 1 of 34