AVERAGE practice

AVERAGE returns the arithmetic mean of its arguments, ignoring empty cells and text. Below are the 2 Excel exercises on Formuladrill 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.

Excel exercises that use AVERAGE

• Class averageLevel 1Free
• An average with the wrong countLevel 7Pro