Excel AVERAGE Practice Question: Using AVERAGE, find the average sales of the last three months only (Apr to…
The question
Using AVERAGE, find the average sales of the last three months only (Apr to Jun) and put it in E2.
The data
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Month | Sales (Lakh) | Last 3 months | ||
| 2 | Jan | 40 | ? | ||
| 3 | Feb | 45 | |||
| 4 | Mar | 50 | |||
| 5 | Apr | 55 | |||
| 6 | May | 60 | |||
| 7 | Jun | 65 |
The yellow cell is where your answer goes.
Show answer
Answer in E2: 60
How it works
Explanation: Pick only the part of the range you need. Here that is the last three rows, which shows the recent trend.
Syntax: =AVERAGE(B5:B7)
Apr, May and Jun are 55, 60 and 65. (55 + 60 + 65) / 3 = 60.
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 the average daily footfall for the five weekdays and put it in B7.
- 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…
- 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