download Mastguru Android App

MS Excel Questions Answers Online Quiz Test

  • 1. With which of the following all formulas in excel starts ?

    1. /
    2. *
    3. $
    4. =
  • 2. On an excel sheet the active cell in indicated by ?

    1. A dotted border
    2. A dark wide border
    3. A blinking border
    4. By italic text
  • 3. What term describes explanatory text attached to a cell ?

    1. Context
    2. Callout
    3. Comment
    4. Dialog
  • 4. How we can view a cell comment ?

    1. position the mouse pointer over the cell
    2. click the comment command on the view menu
    3. click the edit comment commands on the Insert menu
    4. click the Display comment command on the window menu
  • 5. Which of these will not select all the cells in a document ?

    1. Using the Edit – Select All menu
    2. Pressing Ctrl + A on the keyboard
    3. Clicking three times with the right mouse button in the spreadsheet
  • 6. The default style for new data keyed in a new workbook is ?

    1. Comma
    2. Normal
    3. Currency
    4. Percent
  • 7. If you press ___, the cell accepts your typing as its contents ?

    1. Tab
    2. Ctrl+Enter
    3. Enter
    4. Alt+Enter
  • 8. Which of the following keyboard shortcut can be used for creating a chart from the selected cells ?

    1. F11
    2. F10
    3. F4
    4. F2
  • 9. Formula palette is used to ?

    1. format cells containing numbers
    2. create and edit formulas containing functions
    3. entered assumptions data
    4. copy all cells
  • 10. A value used in a formula that does not change is called a ?

    1. Constant
    2. Cell address
    3. Varaible
    4. Static
  • 11. A Spreadsheet contains ?

    1. columns
    2. rows
    3. rows and columns
    4. None of above
  • 12. To open an existing workbook, click the Open button on the ___ toolbar ?

    1. Form
    2. Standard
    3. Drawing
    4. Formatting
  • 13. Which among following is not associated with spelling dialogue box ?

    1. Edit
    2. Ignore
    3. Ignore All
    4. Change
  • 14. what term describes a background that appears as a grainy, non smooth surface ?

    1. Pattern
    2. Gradient
    3. Texture
    4. Velvet
  • 15. Which among following is associated with excel ?

    1. Graphic program
    2. Word Processor
    3. Presentation
    4. Spreadsheet
  • 16. The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ?

    1. C1:10H
    2. C1:H10
    3. C1:H-10
    4. C1:H:10
  • 17. You can convert existing Excel worksheet data and charts to HTML document by using the ?

    1. Internet Assistant Wizard
    2. Intranet Wizard
    3. Import Wizard
    4. Export Wizard
  • 18. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ?

    1. HTML
    2. Pivot Table Field List
    3. Pivot Table Report
    4. Pivot Table List
  • 19. What function displays row data in a column or column data in a row ?

    1. Transpose
    2. Index
    3. Rows
    4. Hyperlinks
  • 20. Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ?

    1. NOT
    2. OR
    3. IF
    4. AND
Submit Quiz
Post a comment

  • Swati 6 years ago

    Hi