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
B. Write T for true and F for false:
1. In a column chart, categories are organized along the horizontal axis and values along the vertical axis.
Answer: T
2. Filtering means sorting data.
Answer: F
3. When the data changes, the chart is updated automatically.
Answer: T
4. We can sort data only in ascending order in a worksheet.
Answer: F
5. Value Axis is also known as x-axis.
Answer: F
6. Category axis is the horizontal axis of the chart.
Answer: T
C. Fill in the blanks:
1. _____________ help us to manage and analyse data.
Answer: Subtotal
2. _____________ is a powerful tool for consolidating, summarising and presenting data.
Answer: Pivot Table
3. ____________ are the bars, slices or other elements that represent the data values.
Answer: Data Series
4. ____________ is used to restrict the cell entries within a specified range.
Answer: Data Validation
5. _____________ means arranging data either in ascending or descending order.
Answer: Sorting
6. A __________ is a pictorial representation of data.
Answer: Chart
D. Answer the following questions:
1. What is a chart? Name some components of a chart.
Answer: Charts are pictorial representation of the data.
Component of chart are:
1. Chart Area
2. Category Axis
3. Value Axis
4. Data Series
5. Chart Title
2. How is a column chart different from a Bar chart?
Answer:
Column Chart: A column chart is a commonly used chart type to display data in the form of vertical bars. It is used to show changes in data over a period of time or comparisons among different data items.
Bar Chart: A bar chart displays the comparisons among individual items as a set of horizontal bars. A bar chart is similar to a column chart except that in this type of chart, the values are represented on the horizontal axis whereas categories are represented on the vertical axis.
3. What is the use of the sorting feature in excel?
Answer: Sorting: Sorting means arranging data either in an ascending or in a descending order in a worksheet. Data can be sorted in rows on the basis of text, numbers, combination of text and numbers or dates.
4. State the use of PivotTable.
Answer: A pivot table is a data summarization tool that allows users to analyze and understand large datasets by reorganizing, summarizing, and grouping data in various ways.
5. How is sorting different from filtering data in Excel?
Answer: Sorting: Sorting means arranging data either in an ascending or in a descending order in a worksheet. Data can be sorted in rows on the basis of text, numbers, combination of text and numbers or dates.
Filtering Data: The filter feature allows us to see only those records that we want to display, temporarily hiding the rest of the data from view. We can say that viewing only selective data that satisfies a given condition is known as filtering data.
6. How is conditional formatting useful to us?
Answer: Conditional formatting is a feature that allows us to set a cell's format according to conditions that we specify.
Conditional formatting is a feature in excel that lets us apply formatting such as cell shading or font colour to a cell only when the cell contents satisfy a given condition.
SOME OTHER LINKS:
No comments:
Post a Comment