Excel practice · Data Tools

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

  1. Show only the West region
  2. Show only revenue over $200
  3. Show only open tickets
  4. Find every "Pro" item in inventory
  5. Find reps under the commission cap
  6. Alphabetize a client list
  7. Rank products by revenue
  8. Put orders in shipping order
  9. Rank reps by commission, not deal count
  10. Rank tied scores without reshuffling them

The exercises

1. Show only the West region Medium

A national sales log covers every region. Filter it down to just the West region rows.

ABC
1RegionRepSales
2WestMaya320
3EastOwen210
4WestPriya180
5SouthNoah150
6EastLena275
7WestSam90
8NorthRavi130
9SouthAya200

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.

2. Show only revenue over $200 Medium

A product list mixes small and large revenue lines. Filter down to only the products bringing in more than $200.

ABC
1ProductCategoryRevenue
2WidgetHardware150
3GadgetHardware320
4Service PlanServices90
5Pro LicenseSoftware410
6Basic LicenseSoftware60
7Support PackageServices250

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.

3. Show only open tickets Medium

A support queue mixes closed tickets in with the ones still needing attention. Filter down to everything that isn't Closed.

ABC
1TicketStatusPriority
2#101OpenHigh
3#102ClosedLow
4#103In ProgressMedium
5#104ClosedHigh
6#105OpenLow

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.

4. Find every "Pro" item in inventory Medium

Inventory wants to check stock on every item in the "Pro" line, wherever "Pro" appears in the name.

ABC
1ItemSKUIn stock
2Pro HeadsetHP-10012
3Basic MouseBM-20040
4Pro KeyboardPK-3008
5Wireless MouseWM-40015
6Pro Monitor StandPMS-5005

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.

5. Find reps under the commission cap Hard

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.

ABCD
1RepRegionDealsCommission
2MayaWest5620
3OwenEast3410
4PriyaWest7500
5NoahSouth2275
6LenaEast6590
7SamNorth4480

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.

6. Alphabetize a client list Medium

This client list is in no particular order. Sort it alphabetically by client name, A to Z.

AB
1ClientBalance
2Nova Retail1240
3Ardent Group400
4Kessler Co860
5Bright Path2100

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.

7. Rank products by revenue Medium

Rank these products from highest revenue to lowest. Sort them, don't just read the numbers.

AB
1ProductRevenue
2Widget150
3Gadget320
4Gizmo90
5Doohickey410

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.

8. Put orders in shipping order Medium

Put these orders in the order they shipped, earliest first.

AB
1OrderShip Date
2#3012026-03-14
3#3022026-01-02
4#3032026-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.

9. Rank reps by commission, not deal count Hard

Finance wants this ranked by commission earned, highest first. Deals closed isn't the question here.

ABC
1RepDealsCommission
2Maya5620
3Owen3410
4Priya7500
5Noah2275

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.

10. Rank tied scores without reshuffling them Hard

Rank these teams by score, highest first. Two pairs are tied. Sort them anyway and see what happens to the tied pairs.

AB
1TeamScore
2Falcons80
3Eagles95
4Hawks80
5Owls95

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 →

More data tools practice

All Excel practice exercises · Excel test prep