Excel case study
What's the average satisfaction score?
Real problems with no formula named for you. You decide what to use.
A customer survey export includes a respondent ID column you won't need. Find the average satisfaction score out of 5.
The data
| A | B | |
|---|---|---|
| 1 | Respondent ID | Score |
| 2 | 5041 | 4 |
| 3 | 5042 | 5 |
| 4 | 5043 | 3 |
| 5 | 5044 | 5 |
| 6 | 5045 | 4 |
| 7 | Average |
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
Ignoring an ID-like column is a small habit that saves you from a badly broken formula later.
More case studies
- How many orders shipped late?
- Work out this order's shipping cost
- Break down spending by department and category
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 →