AVERAGE practice
AVERAGE returns the arithmetic mean of its arguments, ignoring empty cells and text. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.
Syntax
AVERAGE(number1, [number2], ...)
What people get wrong
Empty cells are skipped but zeros count, so a zero typed where a blank was meant pulls the average down.
Google Sheets exercise that use AVERAGE
- Average order valueLevel 1Free
Practice AVERAGE now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free