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. Excel files have a extension ___________ doc xlsx xlm txt2. The name box Appears to the right of the formula bar Shows the location of the active cell Appears below the menu bar Appears below the status bar3. In MS Excel, keyboard shortcut keys to create a new workbook is _____ Ctrl + W Shift + N Ctrl + N Alt + N4. A typical worksheet has ________ number of columns 16843 16348 16384 168445. MS Excel stands for ___________ Microsoft Excess Management Excel Micromax Excel Microsoft Excel6. The first cell in excel worksheet is _______ B1 A1 AB AA7. Which of the following methods can be used to edit the contents of a cell? Clicking the formula bar Press the Alt key Double clicking the cell Pressing the F2 key8. Which key do you press to check spelling? F12 F4 F7 F69. You can edit a cell by Using Name Box Selecting Edit > Edit Cell from the menu Clicking the formula button Double clicking the cell to edit it in-place10. In a worksheet you can select Columns Rows All of these The entire worksheet11. Which symbol must all formula begin with? @ # = +12. In Microsoft Excel spreadsheets, CELLS are labelled as _______ A1,B1,C1…. I,II,III,….. A,B,C,…. 1,2,3,…..13. A ________ is a grid with labeled columns and rows. Worksheet Clipboard Dialog box Toolbar14. Which menu option can be used to split windows into two View > window > split Window > split View > split Format > window15. Excel displays the current cell address in the ________ Status Bar Formula bar Name Box Title Bar16. In Microsoft Excel spreadsheets, rows are labelled as _______ A,B,C,…. A1,B1,C1…. 1,2,3,….. I,II,III,…..17. The intersection of a column and a row in MS Excel worksheet is known as _______ Rows Tab Cell Columns18. Which of the following is the latest version of Excel Excel 2010 Excel 2019 Excel 2016 Excel 200719. Which is used to perform what if analysis? Data Table Goal seek Scenario Manager All of these20. In Microsoft Excel spreadsheets, COLUMNS are labelled as _______ I,II,III,….. A1,B1,C1…. 1,2,3,….. A,B,C,….21. Which of the following is not a term of MS-Excel? Cells Columns Document Rows22. Which area in an excel window allows entering values and formulas Menu bar Name Box Title bar Formula bar23. How many worksheets can we added in a workbook? 256 255 105 25724. MS Excel is a ________ Database Management software Presentation software Spreadsheet software Workbook software25. You can activate a cell by Pressing an arrow key Clicking the cell Pressing the Tab key All of the above26. Comments put in cells are called Smart Tip Web Tip Soft Tip Cell Tip27. A typical worksheet has ________ number of rows 1048576 1047859 1048577 104856728. ___________ is a collection of cells organized in rows and columns where you keep and manipulate the data. ARRAY Spreadsheet Workbook Worksheet29. Comments can be edited using _____ Insert > Comments File > Comments Review > Comments Edit > Comments30. Which of the following options is not located in the Page Setup dialog box? Page Orientation Margins Page Break Preview Headers and Footers31. 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 key32. To view a cell comment Click the display comment command on the window menu Position the mouse pointer over the cell Click the comment command on the view menu Click the edit comment command on the insert menu33. Which of the following methods can not be used to edit the contents of a cell? Double clicking the cell Pressing the F2 key Press the Alt key Clicking the formula bar34. Comments can be added to cells using Edit > Comments File > Comments Review > Comments Insert > Comments Loading …Question 1 of 34