Level 1Core FunctionsPractice, 2 min
AVERAGE
The task
In B7, find the class average of the five test scores.
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | |
|---|---|---|
| 1 | Student | Score |
| 2 | Maya | 88 |
| 3 | Theo | 92 |
| 4 | Priya | 79 |
| 5 | Jonah | 95 |
| 6 | Lena | 81 |
| 7 | Average |