Detailed · Deep study
1Sorting and searching
- Select all the data (including every column), so that rows stay together when sorting.
- Sort on a single criterion (e.g. Surname A–Z) or multiple criteria (e.g. Form, then Surname).
- Use a filter (autofilter or advanced filter) to show only rows that meet the criteria; hidden rows are not deleted.
| Criterion | Shows rows where… |
|---|---|
| >100 | the value is more than 100 |
| <>"Kenya" | the value is anything except Kenya |
| >=10 AND <=20 | the value is from 10 to 20 |
| "A" OR "B" | the value is A or B |
| K* | the text starts with K (* = any characters) |
| ?at | three letters ending in "at" (? = one character) |
2Exam focus
Key words: sort; ascending; descending; filter; criteria; wildcard.
Quick self-check
Answer in your head first, then reveal.
So that each row stays together and data is not mismatched (1).
>=5 AND <=10 (2).
