MS Excel Questions Answers

• 22. Protection and the Protect Sheet options can be selected from ?

  1. Data
  2. Tools
  3. Edit
  4. Format

  Answer And Explanation

  Answer: Option B

  Explanation:

  • View Answer
  • Comment on this question

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

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

  Answer And Explanation

  Answer: Option D

  Explanation:

  • View Answer
  • Comment on this question

• 24. You can check the conditions against ____ when applying conditional formatting ?

  1. Cell Value
  2. Formula
  3. Both of above
  4. None of above

  Answer And Explanation

  Answer: Option C

  Explanation:

  • View Answer
  • Comment on this question

• 25. How can we set Page Border in Excel ?

  1. From Edit menu
  2. From Home
  3. You can not set page border in Excel
  4. From Tools menu

  Answer And Explanation

  Answer: Option C

  Explanation:

  • View Answer
  • Comment on this question

• 26. Which function calculates your monthly mortage payment ?

  1. PV
  2. NPER
  3. PMT
  4. All of above

  Answer And Explanation

  Answer: Option C

  Explanation:

  • View Answer
  • Comment on this question

• 27. Which types of charts can excel produce ?
  

  1. Line graphs and pie charts only
  2. Bar charts, line graphs and pie charts
  3. Bar charts and line graphs only
  4. Only line graphs

  Answer And Explanation

  Answer: Option B

  Explanation:

  • View Answer
  • Comment on this question

• 28. How is data organized in a spreadsheet ?

  1. Rows and columns
  2. Layers and planes
  3. Lines and spaces
  4. Height and width

  Answer And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question