MS Excel Questions Answers

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

    1. /
    2. *
    3. $
    4. =
    Answer And Explanation

    Answer: Option D

    •

  • 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
    Answer And Explanation

    Answer: Option B

  • 3. What term describes explanatory text attached to a cell ?

    1. Context
    2. Callout
    3. Comment
    4. Dialog
    Answer And Explanation

    Answer: Option C

  • 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
    Answer And Explanation

    Answer: Option A

  • 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
    Answer And Explanation

    Answer: Option C

  • 6. The default style for new data keyed in a new workbook is ?

    1. Comma
    2. Normal
    3. Currency
    4. Percent
    Answer And Explanation

    Answer: Option B

  • 7. If you press ___, the cell accepts your typing as its contents ?

    1. Tab
    2. Ctrl+Enter
    3. Enter
    4. Alt+Enter
    Answer And Explanation

    Answer: Option C