Task 1 of 3
In E2, find the class average score.
Lesson theory
=AVERAGE(B2:B8) is the mean, =MIN(…) is the smallest value and
=MAX(…) is the largest value in a range.
It is handy to select the range with the mouse while you are typing the formula.
Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page