About this exercise
A 60-row dataset on one sheet, 3 answer cells, about 4 minutes. Graded in your browser: the value and the formula behind it, with feedback that names the fix.
How to solve it
- G2
=AVERAGE(D2:D61) - G3
=MIN(D2:D61) - G4
=MAX(D2:D61)
AVERAGE, MIN and MAX each take one range and ignore text, so the same D2:D61 feeds all three summary cells.
All three functions accept the same argument — the range of scores — and skip the text header automatically, so =AVERAGE(D1:D61) would still be right. AVERAGE divides the sum by the count of numeric cells (60 here); a blank score would be ignored, a zero would be counted, which is why a missing exam should stay blank rather than be typed as 0. MIN and MAX are the fastest way to spot outliers before you chart anything.
Other ways that work
- =SUM(D2:D61)/COUNT(D2:D61) is what AVERAGE does under the hood.
- =SMALL(D2:D61, 1) and =LARGE(D2:D61, 1) return the lowest and highest value and generalise to 2nd and 3rd place.
- =SUBTOTAL(101, D2:D61) averages only the rows that are visible after filtering.
Common mistakes
Selecting only the first screen of rows (D2:D30) so the range stops early, or typing the numbers in by hand.
How we grade
Any formula that produces the right result is accepted, unless the task names a function: then another function earns half credit. We compare values with a small tolerance and ignore case and spaces in text. A correct number typed by hand instead of a formula earns half credit. Multi-cell tasks earn full credit at 100% of cells, half credit from 50%. Where it matters, we also change an input cell on a copy of your sheet and check that your formula follows.
Answers computed with Excel 365 rules and checked in our grading engine on November 15, 2026. Author: GridBelt team.