Class average
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Six test scores are listed. Put the average score in B8.
What this exercise teaches
AVERAGE adds the numbers and divides by how many there are, ignoring empty cells.
A hint if you get stuck
There is a function named after the thing you want.
Try it now, no account needed
This exercise is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.
Open this exercise