- Foundation
- About 13 min
- 5 practice questions
Sorting, filtering and charts
Sort and filter a data list and pick a suitable chart for the story the numbers tell.
If something looks wrong, please tell us.
Once data is entered, you often need to arrange it, search through it and show it as a picture. Sorting, filtering and charts do these jobs.
Sorting
Sorting rearranges rows in order: ascending (A to Z, smallest to largest) or descending (Z to A, largest to smallest). When sorting, include all columns so each row stays together.
Filtering
Filtering hides rows that do not match a condition and shows only the ones you want, for example marks above 60. The hidden data is not deleted.
Charts
| Chart | Best for |
|---|---|
| Column / bar | Comparing values between categories |
| Line | Showing change over time |
| Pie | Showing parts of a whole |
| Scatter | Showing how two measures relate |
Worked examples
Example 1. Marks are 72, 55, 90, 63. Sorted descending they read 90, 72, 63, 55.
Example 2. Filter for marks above 60 from the same list. The rows with 72, 90 and 63 stay visible; 55 is hidden.
Example 3. Which chart suits monthly sales over a year? A line chart, because it shows change over time.
Example 4. Which chart shows the share of a family budget spent on food, rent and travel? A pie chart, since the parts make a whole.
Sort = reorder, Filter = show matching rows only, Pie = parts of a whole, Line = trend over time.
Key takeaways
- Sorting orders rows; filtering hides the rest.
- Choose the chart by what you want to show.
- Select the whole table before sorting.
Check your understanding
-
1. Marks 7, 3, 9 and 1 are sorted in descending order. What is the result?
- 1, 3, 7, 9
- 9, 7, 3, 1
- 7, 3, 9, 1
- 9, 3, 7, 1
Show answer
Answer: B. Descending means largest to smallest: 9, 7, 3, 1.
-
2. A filter is set to show marks above 60. What happens to the rows with lower marks?
- They are deleted permanently
- They are hidden but not deleted
- They are moved to a new worksheet
- They are sorted to the bottom of the list
Show answer
Answer: B. Filtering only hides rows that do not match the condition; the data is still there.
-
3. Which chart best shows the share of a family budget spent on food, rent and travel?
- Line chart
- Scatter chart
- Pie chart
- Column chart
Show answer
Answer: C. A pie chart shows parts of a whole, such as each item's share of a budget.
-
4. Which chart best shows how the height of each student relates to the student's weight?
- Pie chart
- Scatter chart
- Column chart
- Line chart
Show answer
Answer: B. A scatter chart shows how two measures relate to each other.
-
5. Why should all the columns of a table be selected before sorting it?
- So each row's data stays together
- So the sort runs faster
- So blank columns are deleted
- So a chart is created
Show answer
Answer: A. If only one column is sorted, its values move while the rest stay, and each name no longer matches its own marks.
Sign in to keep track of the lessons you finish.