- Practice
- About 13 min
- 5 practice questions
Sorting, filtering, charts and data tools
Choose between sort, filter and chart types, and answer questions on the order and meaning of results.
If something looks wrong, please tell us.
Spreadsheets are also used to organise and show data. Questions here are about choosing the right tool for the job.
Sorting and filtering
- Sort rearranges rows in ascending (smallest to largest, A to Z) or descending order.
- Filter hides rows that do not meet a condition, without deleting them.
- Find and Replace locate and change values in the sheet.
Chart types
| Chart | Best for |
|---|---|
| Column or bar | Comparing values across categories |
| Line | Showing change over time |
| Pie | Showing parts of a whole |
| Scatter | Showing the relationship between two numbers |
Worked examples
Example 1. Marks are 72, 45, 90 and 61. Sort in descending order. Largest first: 90, 72, 61, 45.
Example 2. A shop wants to show how its monthly sales changed over twelve months. Which chart? A line chart, because it shows change over time. To show each product's share of total sales, a pie chart would be better.
Sort rearranges, filter hides. Line = time, pie = parts of a whole, column = comparison.
Key takeaways: sort arranges, filter hides, and the chart type must suit the story in the data.
Check your understanding
-
1. Which tool shows only the rows that meet a condition and hides the others?
- Sort
- Filter
- Find
- Merge
Show answer
Answer: B. A filter hides rows that do not meet the condition without deleting them. Sort only changes the order.
-
2. A shop wants to show how its monthly sales changed over twelve months. Which chart is best?
- Pie chart
- Line chart
- Scatter chart
- Doughnut chart
Show answer
Answer: B. A line chart shows change over time. Pie and doughnut charts show parts of a whole; a scatter chart relates two numbers.
-
3. Marks 38, 91, 64 and 70 are sorted in descending order. What is the result?
- 38, 64, 70, 91
- 91, 64, 70, 38
- 91, 70, 64, 38
- 38, 91, 64, 70
Show answer
Answer: C. Descending means largest to smallest: 91, 70, 64, 38.
-
4. Which chart is best for comparing the marks of five students?
- Line chart
- Column chart
- Pie chart
- Scatter chart
Show answer
Answer: B. Column (or bar) charts compare values across separate categories, here the students.
-
5. What do Find and Replace do in a spreadsheet?
- Hide rows that do not match
- Locate values and change them
- Put rows in ascending order
- Turn data into a chart
Show answer
Answer: B. Find locates a value and Replace changes it. Hiding rows is filtering and ordering rows is sorting.
Sign in to keep track of the lessons you finish.