Excel case study
Which SKU has the most stock?
Real problems with no formula named for you. You decide what to use.
Warehouse pulled a stock export with manager names attached. Find which SKU has the highest quantity on hand. You decide how.
The data
| A | B | C | |
|---|---|---|---|
| 1 | SKU | Manager | Qty On Hand |
| 2 | BX-1 | Farah | 340 |
| 3 | BX-2 | Owen | 512 |
| 4 | BX-3 | Priya | 275 |
| 5 | BX-4 | Lucas | 600 |
| 6 | BX-5 | Maya | 410 |
| 7 | Highest Qty |
This is the actual sheet the case study hands you, including whatever column turns out not to matter. Figuring out what to ignore is part of the exercise.
Why this one matters
The Manager column is a distractor again on purpose. Real exports carry fields you'll never touch.
More case studies
- What's the average satisfaction score?
- How many orders shipped late?
- Work out this order's shipping cost
Case Studies are part of the full unlock
Case Studies are locked until you unlock the full site: real, messier problems with no function named for you, graded the same way every Practice exercise is. Open this one to see how to unlock the rest.
Open this case study →