MIN, MAX and AVERAGE
Find the lowest grade, the highest grade and the class average in a student grade sheet using MIN, MAX and AVERAGE — 3 guided steps.
Write the formula in cell B13
1 / 3
Lowest grade (MIN)
=MIN(B2:B11)
Write the formula in cell B14
2 / 3
Highest grade (MAX)
=MAX(B2:B11)
Write the formula in cell B15
3 / 3
Class average (AVERAGE)
=AVERAGE(B2:B11)
Your score is