MS Excel Questions Answers

• 15. How do you change column width to fit the contents ?

  1. Single-click the boundary to the left to the column heading
  2. Double click the boundary to the right of the column heading
  3. Press Alt and single click anywhere in the column
  4. All of above

  Answer :

  Option B

• 16. How many recent files you can display on File menu at maximum ?

  1. 3
  2. 7
  3. 9
  4. 15

  Answer :

  Option C

• 17. 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 :

  Option B

• 18. Entire worksheet can not be selected in one time.

  1. True
  2. False

  Answer :

  Option B

• 19. Which of the following is not a valid Zoom percentage in Excel ?

  1. 10
  2. 100
  3. 300
  4. 500

  Answer :

  Option D

• 20. Which of the following keyboard shortcut can be used for creating a chart from the selected cells ?

  1. 125.33%
  2. 128.33%
  3. 131.33%
  4. 133.33%
  5. F11
  6. F10
  7. F4
  8. F2

  Answer :

  Option E

• 21. 3-D reference in a formula ?

  1. Two Wheeler
  2. Jeeps
  3. Light Commercial Vehicles
  4. Cars
  5. Spans worksheets
  6. Can not be modified
  7. Only appears on summary worksheets
  8. Limits the formatting options

  Answer :

  Option E