CBSE SOLUTIONS-2026-27
CLASS-7
CHAPTER-3 MS Excel 2021: Advance Features
1. Categories are organized along the horizontal axis and values along the vertical axis in a:
(A) Column chart (B) Pie chart (C) Line chart (D) Doughnut chart
Answer: (A) Column chart
2. Each section on a ring displays the contribution of an individual item to the total of all items in a particular series in:
(A) Bar charts (B) Pie charts (C) Doughnut charts (D) Scatter charts
Answer: (C) Doughnut charts
3. The bars, slices or other elements that represent the data:
(A) Data series (B) Plot area (C) Gridlines (D) Data tables
Answer: (A) Data series
4. You use it to restrict cell entries within a specified range:
(A) Filter feature (B) Values option (C) Sorting data option (D) Data validation
Answer: (D) Data validation
B. Write TRUE or FALSE:
1. Data validation is used to restrict the cell entries within a specified range.
Answer: TRUE
2. In doughnut chart, data series is represented by individual rings.
Answer: TRUE
3. Data can be sorted in rows on the basis of text and numbers or dates.
Answer: TRUE
4. A hierarchy chart plots data in concentric circles with each axis representing a different variable extending outward from a central point.
Answer: FALSE
5. Conditional Formatting is a feature in MS Excel that lets you apply formatting.
Answer: TRUE
C. Fill in the blanks with the words given below:
(arrows Data values analyse)
1. Subtotals help you to organise and analyse the data by grouping and summarising ________ .
Answer: Data
2. The Filter ________ appear next to the column headings.
Answer: arrows
3. Once data is organised, it becomes easy to ________ and work with.
Answer: analyse
4. To apply data validation, select the range, then click on the Data Validation option in the Data Tools on the ________ tab.
Answer: Data
D. Answer these questions:
1. What do you understand by a chart in MS Excel 2021? Name its components.
A chart in MS Excel is a visual representation of data that helps in understanding trends, patterns, and comparisons easily.
Components: Chart Area, Plot Area, Data Series, Axes (X-axis and Y-axis), Chart Title, Axis Titles, Legend, Gridlines, Data Labels, Data Table.
2. What is the difference between a Column chart and a Bar chart?
Column Chart: Categories are on the horizontal axis and values on the vertical axis. Bars are vertical.
Bar Chart: Categories are on the vertical axis and values on the horizontal axis. Bars are horizontal.
3. Describe the uses of the sorting feature in MS Excel.
Sorting arranges data in ascending or descending order based on text, numbers, or dates. It helps organize data, find maximum/minimum values quickly, and prepare structured reports.
4. What is a PivotTable? Mention its use.
A PivotTable is a powerful tool used to summarize, analyze, and explore large amounts of data. It allows dynamic grouping, filtering, and calculation of totals, averages, etc., without writing complex formulas.
No comments:
Post a Comment