All lessons
Excel Basicsbeginner
AVERAGE, MAX & MIN
Summarize a list of numbers at a glance — the three functions you'll use constantly in any report.
0 of 2 exercises complete
Find the average
In cell B7, find the average test score using AVERAGE(B2:B6).
Find the highest and lowest
In cell B8, find the highest score with MAX(B2:B6). In cell B9, find the lowest score with MIN(B2:B6).