Filtering data and review
Answers are for parents and teachers.
1
Ages 10, 13, 14, 16, 18. How many records does “over 13 AND under 17” keep?
2
2
If each of 3 filtered products costs 1200 so‘m, what is the visible total?
3600
3
If the birth year is 2011 and the current year is 2026, what is the age?
15
4
Why check the result after sorting a table?
If the selection was wrong, the data may no longer match, or the letter order may differ from what you expect.
5
Put the steps in the right order: filtering, building the table, formulas, sorting.
Building the table → formulas → sorting → filtering.