CBSE SOLUTIONS-2025-26
CLASS-7
CHAPTER-3 CHARTS IN MS EXCEL
A. Tick the correct answer:
1. Which feature allows us to arrange the given data according to a particular field either in an ascending or in a dscending order?
a. Data Validation b. Filter c. Sort d. Goal Seek
Answer: Sort
2. Where all chart components are found, it is the area within:
a. Chart area b. Database c. Axis Title d. Data
Answer: Chart Area
3. Which of the following charts plots data series as rings?
a. Bar chart b. Line chart c. Pie chart d. Doughnut chart
Answer: Doughnut chart
4. Which feature is used to set a specific result for one cell by adjusting a value in another cell?
a. Legends b. Goal Seek c. Filter d. Sorting
Answer: Goal Seek
5. Which feature lets us apply formatting to a cell only when the value in the cell satisfies a given condition?
a. Conditional formatting b. Goal seek c. Filter d. None of these
Answer: Conditional Formatting
6. Which component of a chart depicts the colours, patterns and symbols assigned to a data series?
a. Gridlines b. Plot Area c. Legend d. Data Marker
Answer: Legend