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

  • Comment on this question

• 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

  • Comment on this question

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

  1. Context
  2. Callout
  3. Comment
  4. Dialog

  Answer And Explanation

  Answer: Option C

  • Comment on this question

• 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

  • Comment on this question

• 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

  • Comment on this question

• 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

  • Comment on this question

• 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

  • Comment on this question