# Charts and summaries

> A chart comparing magnitudes across categories.

Course: [Spreadsheet skills](https://studybrix.com/en/courses/spreadsheets/index.md)
Level: university
Prerequisites: Basic arithmetic and computer literacy.

## Notes

### Bar chart

A chart comparing magnitudes across categories.

### Line chart

A chart often used to show ordered change such as a time series.

### Pivot table

An interactive summary that groups and aggregates tabular data.

### Chart title

A concise description of what a chart displays, including enough context to interpret it.

## Practice questions

### 1. Which term best matches this description: A chart comparing magnitudes across categories.

A. Bar chart
B. Chart title
C. Line chart
D. Pivot table

Answer: Bar chart

Explanation: Bar chart is the matching concept in this lesson.

### 2. Which term best matches this description: A chart often used to show ordered change such as a time series.

A. Pivot table
B. Chart title
C. Line chart
D. Bar chart

Answer: Line chart

Explanation: Line chart is the matching concept in this lesson.

### 3. Which concept would you apply first in a situation where an interactive summary that groups and aggregates tabular data.

A. Chart title
B. Line chart
C. Pivot table
D. Bar chart

Answer: Pivot table

Explanation: The scenario directly calls for Pivot table.

### 4. Name the concept described as: A concise description of what a chart displays, including enough context to interpret it.

Answer: Chart title

Explanation: The intended concept is Chart title.

### 5. Which statement about Bar chart is most accurate?

A. A chart comparing magnitudes across categories.
B. A concise description of what a chart displays, including enough context to interpret it.
C. A chart often used to show ordered change such as a time series.
D. An interactive summary that groups and aggregates tabular data.

Answer: A chart comparing magnitudes across categories.

Explanation: The definition in the lesson notes gives the required condition.

### 6. Explain one important difference between Bar chart and Line chart.

Sample answer / marking guidance: Bar chart: A chart comparing magnitudes across categories. Line chart: A chart often used to show ordered change such as a time series.

Explanation: Credit a clear distinction using both definitions and an appropriate example if supplied.

### 7. Give a short example showing how Pivot table would be used in practice.

Sample answer / marking guidance: A valid example should demonstrate this idea: An interactive summary that groups and aggregates tabular data.

Explanation: Credit a relevant scenario that applies the concept rather than merely naming it.

### 8. Summarize why Chart title matters in the lesson “Charts and summaries”.

Sample answer / marking guidance: Chart title matters because A concise description of what a chart displays, including enough context to interpret it.

Explanation: Credit the core purpose, scope and any important limitation from the notes.

## Further reading

- https://support.microsoft.com/excel

Original AI-assisted educational draft; not independently teacher-reviewed. References support further study, not copied exercises, affiliation or curriculum accreditation.