Excel AVERAGE Practice Question: In a judged contest, the highest and lowest scores are dropped. Using SUM,…
The question
In a judged contest, the highest and lowest scores are dropped. Using SUM, MAX, MIN and COUNT, find the average of the remaining scores and put it in B7.
The data
| A | B | |
|---|---|---|
| 1 | Judge | Score |
| 2 | Judge 1 | 8.5 |
| 3 | Judge 2 | 9 |
| 4 | Judge 3 | 7.5 |
| 5 | Judge 4 | 9.5 |
| 6 | Judge 5 | 8 |
| 7 | Final | ? |
The yellow cell is where your answer goes.
Show answer
Answer in B7: 8.5
How it works
Explanation: To drop the extremes, take them off the total and reduce the count by 2. Then divide what is left by what remains.
Syntax: =(SUM(range)-MAX(range)-MIN(range))/(COUNT(range)-2)
Total = 42.5. Remove 9.5 and 7.5 leaves 25.5. Count is 5 - 2 = 3. 25.5 / 3 = 8.5.
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
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…
- 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…
All practice questions · Excel exercises · Interview prep · Cheat sheet