0 of 46 lessons complete.
Module 2: Core Functions · Lesson 11 of 46
AVERAGE Function
Find the mean of a range with AVERAGE.
Step 1 of 10%
In B10, use AVERAGE to find the average temperature for the shift.
Target: B10
A1
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Hour | Temp (°F) | ||||
| 2 | 8:00 | 68 | ||||
| 3 | 9:00 | 71 | ||||
| 4 | 10:00 | 74 | ||||
| 5 | 11:00 | 77 | ||||
| 6 | 12:00 | 79 | ||||
| 7 | 13:00 | 76 | ||||
| 8 | 14:00 | 72 | ||||
| 9 | 15:00 | 69 | ||||
| 10 | Average | |||||
| 11 |
Arrow keys move · drag or shift-click to select a range · Ctrl/Cmd+D fill down · Ctrl/Cmd+R fill right · Alt+= AutoSum · F4 toggles $