Excel filters & sorting practice exercises
10 graded problems with realistic data, from medium to hard.
Not a function, two tools. Filter hides rows that don't match a condition; Sort reorders every row by a column. Neither one calculates anything. The 10 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.
New to the function? Read the Filters & sorting guide first: syntax, a worked example and the mistakes people make.
In this set
- Show only the West region
- Show only revenue over $200
- Show only open tickets
- Find every "Pro" item in inventory
- Find reps under the commission cap
- Alphabetize a client list
- Rank products by revenue
- Put orders in shipping order
- Rank reps by commission, not deal count
- Rank tied scores without reshuffling them
The exercises
A national sales log covers every region. Filter it down to just the West region rows.
| A | B | C | |
|---|---|---|---|
| 1 | Region | Rep | Sales |
| 2 | West | Maya | 320 |
| 3 | East | Owen | 210 |
| 4 | West | Priya | 180 |
| 5 | South | Noah | 150 |
| 6 | East | Lena | 275 |
| 7 | West | Sam | 90 |
| 8 | North | Ravi | 130 |
| 9 | South | Aya | 200 |
Apply the filter.
Show a hint
Filter the Region column to Equals "West." Every other region should gray out.
A filter never deletes or reorders data. It just hides what you're not looking at right now, and un-filtering brings every row straight back.
A product list mixes small and large revenue lines. Filter down to only the products bringing in more than $200.
| A | B | C | |
|---|---|---|---|
| 1 | Product | Category | Revenue |
| 2 | Widget | Hardware | 150 |
| 3 | Gadget | Hardware | 320 |
| 4 | Service Plan | Services | 90 |
| 5 | Pro License | Software | 410 |
| 6 | Basic License | Software | 60 |
| 7 | Support Package | Services | 250 |
Apply the filter.
Show a hint
Filter the Revenue column to Greater than 200.
A numeric filter like Greater than is the fastest way to focus on what actually matters in a long list: the handful of big numbers, not the whole table.
A support queue mixes closed tickets in with the ones still needing attention. Filter down to everything that isn't Closed.
| A | B | C | |
|---|---|---|---|
| 1 | Ticket | Status | Priority |
| 2 | #101 | Open | High |
| 3 | #102 | Closed | Low |
| 4 | #103 | In Progress | Medium |
| 5 | #104 | Closed | High |
| 6 | #105 | Open | Low |
Apply the filter.
Show a hint
Filter the Status column to Does not equal "Closed." This keeps both Open and In Progress.
"Not equal to" is the right filter whenever what you're excluding is narrower than what you want to keep: one status to hide, instead of listing every status you'd have to include.
Inventory wants to check stock on every item in the "Pro" line, wherever "Pro" appears in the name.
| A | B | C | |
|---|---|---|---|
| 1 | Item | SKU | In stock |
| 2 | Pro Headset | HP-100 | 12 |
| 3 | Basic Mouse | BM-200 | 40 |
| 4 | Pro Keyboard | PK-300 | 8 |
| 5 | Wireless Mouse | WM-400 | 15 |
| 6 | Pro Monitor Stand | PMS-500 | 5 |
Apply the filter.
Show a hint
Filter the Item column to Contains "Pro." It doesn't need to be at the start of the name.
Contains is a text search, not an exact match. It's what you reach for when you know part of a name but not the whole thing, or when a whole product line shares one word.
Finance is auditing commission payouts. Deals closed isn't the question here. Filter down to reps whose commission is at or under the $500 cap.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Rep | Region | Deals | Commission |
| 2 | Maya | West | 5 | 620 |
| 3 | Owen | East | 3 | 410 |
| 4 | Priya | West | 7 | 500 |
| 5 | Noah | South | 2 | 275 |
| 6 | Lena | East | 6 | 590 |
| 7 | Sam | North | 4 | 480 |
Apply the filter.
Show a hint
Deals is a distractor. Filter the Commission column instead, to Less than or equal to 500.
"At or under a cap" is inclusive at the boundary (Less than or equal to, not Less than), and Deals sitting right next to Commission is exactly the kind of plausible-but-wrong column a real audit throws at you.
This client list is in no particular order. Sort it alphabetically by client name, A to Z.
| A | B | |
|---|---|---|
| 1 | Client | Balance |
| 2 | Nova Retail | 1240 |
| 3 | Ardent Group | 400 |
| 4 | Kessler Co | 860 |
| 5 | Bright Path | 2100 |
Sort the table.
Show a hint
Sort by the Client column, Ascending (A→Z).
Alphabetical sort is the most common Data → Sort use. It's the same feature whether the column holds names, cities, or product codes.
Rank these products from highest revenue to lowest. Sort them, don't just read the numbers.
| A | B | |
|---|---|---|
| 1 | Product | Revenue |
| 2 | Widget | 150 |
| 3 | Gadget | 320 |
| 4 | Gizmo | 90 |
| 5 | Doohickey | 410 |
Sort the table.
Show a hint
Sort by the Revenue column, Descending (largest → smallest).
Sorting by a number puts the biggest (or smallest) values first without you having to scan for them by eye.
Put these orders in the order they shipped, earliest first.
| A | B | |
|---|---|---|
| 1 | Order | Ship Date |
| 2 | #301 | 2026-03-14 |
| 3 | #302 | 2026-01-02 |
| 4 | #303 | 2026-02-20 |
Sort the table.
Show a hint
Sort by Ship Date, Ascending. A YYYY-MM-DD date sorts chronologically as plain text because the year comes first.
Sorting a date column works exactly like sorting text, as long as the date is written year-first. That's exactly why LearnExcel (and most real systems) store dates that way.
Finance wants this ranked by commission earned, highest first. Deals closed isn't the question here.
| A | B | C | |
|---|---|---|---|
| 1 | Rep | Deals | Commission |
| 2 | Maya | 5 | 620 |
| 3 | Owen | 3 | 410 |
| 4 | Priya | 7 | 500 |
| 5 | Noah | 2 | 275 |
Sort the table.
Show a hint
Deals is a distractor. Sort by Commission, Descending.
The column with the biggest-looking numbers isn't always the one you should sort by. Read what's actually being asked before picking a column.
Rank these teams by score, highest first. Two pairs are tied. Sort them anyway and see what happens to the tied pairs.
| A | B | |
|---|---|---|
| 1 | Team | Score |
| 2 | Falcons | 80 |
| 3 | Eagles | 95 |
| 4 | Hawks | 80 |
| 5 | Owls | 95 |
Sort the table.
Show a hint
Sort by Score, Descending. Ties stay in their original relative order (a stable sort), so Eagles still comes before Owls, and Falcons still comes before Hawks.
Sorting doesn't need a tiebreaker column to behave predictably. A stable sort (what Excel, and LearnExcel, both do) never shuffles equal values arbitrarily.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the Filters & sorting exercises →