Average three exam scores
You're a teacher wrapping up an exam: the scores for Alex, Betty, and Chris are already in B2:B4, and the report still needs the class average. Fill the Average cell B5 with the mean of the three scores.
Your solution should use cell references so it updates automatically when Test Case input values change.
Test case
1
2
Reset
Submit
A
B
C
D
E
F
G
1
2
3
4
5
6
7
8
9
10
○ Ready Enter formula in highlighted cells, then click Submit.
Test case
1
2
Reset
Submit
A
B
C
D
E
F
G
1
2
3
4
5
6
7
8
9
10
○ Ready Enter formula in highlighted cells, then click Submit.
Notes
AVERAGE ignores text and blank cells by default. For interview prep, know the difference between AVERAGE and AVERAGEA.
Function guide
FAQ
What formula averages B2:B4 in Excel?
Use =AVERAGE(B2:B4). It returns the arithmetic mean of the numeric values in that range.
Does AVERAGE ignore blank cells?
Yes. Blank cells are ignored. Text values are also ignored by AVERAGE (unlike AVERAGEA).