Charts in MS Excel Class 7 MCQs
Charts in MS Excel – Class 7 MCQs with Answers & Explanations
Class: 7
Subject: Computer Science
Section: Spreadsheets (MS Excel)
Topic: Charts in MS Excel
Board: CBSE (Based on NCERT Syllabus)
Subject: Computer Science
Section: Spreadsheets (MS Excel)
Topic: Charts in MS Excel
Board: CBSE (Based on NCERT Syllabus)
1. A chart is used to represent data in:
Answer: b) Graphic form
Charts display data visually, making it easier to understand.
Charts display data visually, making it easier to understand.
2. Charts are created from:
Answer: b) Data in worksheet
Excel uses worksheet data to generate charts.
Excel uses worksheet data to generate charts.
3. Most common chart type:
Answer: a) Column Chart
Column charts compare values easily.
Column charts compare values easily.
4. Pie chart shows:
Answer: b) Parts of whole
Pie charts represent percentage distribution.
Pie charts represent percentage distribution.
5. Bar chart is similar to:
Answer: a) Column chart
Both compare values using bars.
Both compare values using bars.
6. Line chart shows:
Answer: b) Trends over time
Useful for progress and growth analysis.
Useful for progress and growth analysis.
7. Chart title describes:
Answer: b) Chart topic
Title explains chart meaning.
Title explains chart meaning.
8. Legend explains:
Answer: d) All
Legend identifies chart elements.
Legend identifies chart elements.
9. X-axis is called:
Answer: b) Horizontal axis
Shows categories.
Shows categories.
10. Y-axis is:
Answer: b) Vertical
Shows values.
Shows values.
11. Chart is inserted from:
Answer: b) Insert tab
12. Data series means:
Answer: b) Group of values
13. Area chart displays:
Answer: d) All
14. Chart helps in:
Answer: d) All
15. Chart wizard guides:
Answer: a) Creation steps
16. 3D charts provide:
Answer: a) Depth view
17. Chart layout changes:
Answer: d) All
18. Data labels show:
Answer: d) All
19. Chart improves:
Answer: d) All
20. Charts are best for:
Answer: d) All
