Home › Practice questions › AVERAGE › Question 6

Excel AVERAGE Practice Question: The store was closed one day, so that day shows 0. Using AVERAGE, find the…

By Rinkesh Shah, founder of Cellgrids.

The question

The store was closed one day, so that day shows 0. Using AVERAGE, find the average daily sales for the five days (zero included) and put it in B7.

The data

	A	B
1	Day	Sales
2	Mon	7000
3	Tue	6500
4	Wed	0
5	Thu	8000
6	Fri	7500
7	Average	?

The yellow cell is where your answer goes.

Show answer

Answer in B7: 5800

How it works

Explanation: A zero is a real number, so AVERAGE counts it. This lowers the average compared with leaving the cell blank.
Syntax: =AVERAGE(B2:B6)
(7000 + 6500 + 0 + 8000 + 7500) / 5 = 29000 / 5 = 5800. If Wednesday were blank, the result would be 7250.

Try it yourself in the live sheet

Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.

Try this question in the live sheet →

AVERAGE syntax

=AVERAGE(number1, [number2], ...)

Finds the mean of a set of numbers. AVERAGE is used in financial models and engineering-style calculations where precise numeric work is needed. Full AVERAGE guide.