MS Excel Questions Answers
-
22. Protection and the Protect Sheet options can be selected from ?
- Data
- Tools
- Edit
- Format
Answer And Explanation
Answer: Option B
-
23. Which of the following is not a valid Zoom percentage in Excel ?
- 10
- 100
- 300
- 500
Answer And Explanation
Answer: Option D
-
24. You can check the conditions against ____ when applying conditional formatting ?
- Cell Value
- Formula
- Both of above
- None of above
Answer And Explanation
Answer: Option C
-
25. How can we set Page Border in Excel ?
- From Edit menu
- From Home
- You can not set page border in Excel
- From Tools menu
Answer And Explanation
Answer: Option C
-
26. Which function calculates your monthly mortage payment ?
- PV
- NPER
- PMT
- All of above
Answer And Explanation
Answer: Option C
-
27. Which types of charts can excel produce ?
- Line graphs and pie charts only
- Bar charts, line graphs and pie charts
- Bar charts and line graphs only
- Only line graphs
Answer And Explanation
Answer: Option B
-
28. How is data organized in a spreadsheet ?
- Rows and columns
- Layers and planes
- Lines and spaces
- Height and width
Answer And Explanation
Answer: Option A