Excel AVERAGE Practice Question: Using AVERAGE, find the average daily footfall for the five weekdays and put…
The question
Using AVERAGE, find the average daily footfall for the five weekdays and put it in B7.
The data
| A | B | |
|---|---|---|
| 1 | Day | Visitors |
| 2 | Mon | 120 |
| 3 | Tue | 135 |
| 4 | Wed | 150 |
| 5 | Thu | 110 |
| 6 | Fri | 135 |
| 7 | Average | ? |
The yellow cell is where your answer goes.
Show answer
Answer in B7: 130
How it works
Explanation: AVERAGE adds the numbers and divides by how many there are. It tells you the typical value.
Syntax: =AVERAGE(number1, [number2], ...)
(120 + 135 + 150 + 110 + 135) / 5 = 650 / 5 = 130.
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.
More AVERAGE practice questions
- Using AVERAGE, find each student's average marks across the three tests and put them in…
- Two students were absent, so their marks are blank. Using AVERAGE, find the average of…
- Customer ratings are on a 5-point scale. Using ROUND with AVERAGE, find the average…
- Store A and Store B report monthly sales in separate columns. Using one AVERAGE with…
- The store was closed one day, so that day shows 0. Using AVERAGE, find the average daily…
- Using AVERAGE, find the average sales of the last three months only (Apr to Jun) and put…
- Build a 3-month moving average. Using AVERAGE, fill C4 to C7 so each cell averages that…
- Using AVERAGE with MAX and MIN, find the midpoint between the highest and lowest mark…
All practice questions · Excel exercises · Interview prep · Cheat sheet