Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
LARGE and SMALL. LARGE(range, k) returns the k-th biggest number in a range: k = 1 is the maximum, k = 2 the runner-up. SMALL(range, k) does the same from the bottom. Put k in a cell and point at it, so one formula fills a whole top-N list. Lock the range with $ before filling down.
=SMALL($C$2:$C$40,A2) the A2-th shortest delivery time
Daniel Ortiz is preparing account reviews and wants the three highest 2025 revenue figures among West customers.
In F2:F4, return the 1st, 2nd and 3rd largest revenue in B2:B32, using the rank number next to each cell in E2:E4. Write it once in F2 and fill down. No rounding.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Customer | Revenue 2025 | Rank | Revenue | ||||
| 2 | Atlas Accounting | 1,589.67 | 1 | |||||
| 3 | Atlas Dental | 2,430.96 | 2 | |||||
| 4 | Beacon Accounting | 4,182.90 | 3 | |||||
| 5 | Bright Fitness | 2,269.48 | ||||||
| 6 | Cedar Accounting | 1,846.23 | ||||||
| 7 | Copper Dental | 1,333.90 | ||||||
| 8 | Falcon Studios | 1,066.78 | ||||||
| 9 | Granite Accounting | 2,511.09 | ||||||
| 10 | Granite Bakery | 874.26 | ||||||
| 11 | Granite Pharmacy | 1,786.50 | ||||||
| 12 | Harbor & Pine Hotels | 39,688.65 | ||||||
| 13 | Harbor Accounting | 1,784.36 | ||||||
| 14 | Harbor Hotels | 3,112.55 | ||||||
| 15 | Harbor Realty | 3,527.11 | ||||||
| 16 | Lakeside Academy | 1,805.93 | ||||||
| 17 | Lakeside Print Co | 2,072.91 | ||||||
| 18 | Maple Consulting | 1,587.23 | ||||||
| 19 | Maple Studios | 1,083.40 | ||||||
| 20 | Meadow Motors | 1,093.96 | ||||||
| 21 | North Academy | 2,479.85 | ||||||
| 22 | Oak Studios | 2,542.59 | ||||||
| 23 | Orchard Bakery | 3,114.87 | ||||||
| 24 | Orchard Logistics | 1,254.95 | ||||||
| 25 | Orchard Media | 2,465.41 | ||||||
| 26 | Pioneer Realty | 1,240.71 | ||||||
| 27 | River Academy | 1,688.89 | ||||||
| 28 | River Print Co | 1,102.82 | ||||||
| 29 | Summit Motors | 2,790.17 | ||||||
| 30 | Willow Hotels | 1,083.27 | ||||||
| 31 | Willow Labs | 2,556.67 | ||||||
| 32 | Willow Logistics | 2,325.08 | ||||||
| 33 | ||||||||
| 34 | ||||||||
| 35 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe