Excel AVERAGE Practice Question: Customer ratings are on a 5-point scale. Using ROUND with AVERAGE, find the…
The question
Customer ratings are on a 5-point scale. Using ROUND with AVERAGE, find the average rating rounded to 1 decimal place and put it in B7.
The data
| A | B | |
|---|---|---|
| 1 | Customer | Rating |
| 2 | C-101 | 4.5 |
| 3 | C-102 | 3.8 |
| 4 | C-103 | 4.1 |
| 5 | C-104 | 4.9 |
| 6 | C-105 | 3.9 |
| 7 | Rating | ? |
The yellow cell is where your answer goes.
Show answer
Answer in B7: 4.2
How it works
Explanation: AVERAGE often gives long decimals. Wrapping it in ROUND keeps a clean figure for reports.
Syntax: =ROUND(AVERAGE(B2:B6),1)
Sum = 21.2. Average = 21.2 / 5 = 4.24. Rounded to 1 decimal: 4.2.
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…
- 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