Average a column with AVERAGE
40%
AVERAGE
AVERAGE adds the numbers in a range and divides by how many there are. The important part is the second half: it counts for you, so the formula stays right when a row is added.
It ignores blank cells and text, and it does count zeros. That last one matters: a zero is a score of nothing, while a blank is no score at all, and they pull an average in different directions.
In B8, use AVERAGE to find the mean of the five test scores in B2 to B6.
The grid for this exercise needs a free profile.
Everything above is yours to read either way. 19 exercises stay open with no profile at all.