Excel & Sheets practice: Distinct Deduplication & Sorting
Chapter 26 · 4 questions · included in full access
Question 1 · easy
Distinct regions, sorted
Solve it in your browserIn K2, spill an alphabetical list of the distinct Regions.
Question 2 · medium
Top 3 orders — Excel
Solve it in your browserSpill the OrderIDs of the three highest-revenue orders, highest first, starting in K2.
Question 3 · easy
SORT, Sheets style
Solve it in your browserSpill all OrderIDs sorted by Revenue, highest first, from K2 — sorting by a column you don't return.
Question 4 · hard
A pivot table without a pivot table
Solve it in your browserBuild a two-column report in K2: each distinct Region (A→Z) next to its total Revenue — all from one spilling formula.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing