Excel MIN Practice Question: Using the sales in B2:B8, find the gap between the best and the weakest sale.…
The question
Using the sales in B2:B8, find the gap between the best and the weakest sale. Put it in D2.
The data
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Rep | Sales | Result | |
| 2 | Asha | 45200 | ? | |
| 3 | Ravi | 52800 | ||
| 4 | Meera | 38750 | ||
| 5 | Karan | 61400 | ||
| 6 | Divya | 47900 | ||
| 7 | Imran | 55300 | ||
| 8 | Sunita | 43100 |
The yellow cell is where your answer goes.
Show answer
Answer in D2: 22650
How it works
Explanation: MAX minus MIN is the range, a quick way to see how spread out the numbers are.
Syntax: =MAX(B2:B8)-MIN(B2:B8)
61400 - 38750 = 22650.
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 →MIN syntax
=MIN(number1, [number2], ...)
Returns the smallest number in a set. MIN is used in data analysis work to summarize or test patterns across a data set. Full MIN guide.
More MIN practice questions
- A sales team's monthly sales are in B2:B8. Find the lowest sale. Put it in D2.
- The daily temperature (in °C) for a week is in B2:B8. What was the coldest day's…
- Two suppliers' prices are in B2:B6 (Supplier A) and C2:C6 (Supplier B). Find the…
- Exam marks are in B2:B8. Two students were Absent (typed as text). Find the lowest mark.…
- A shop made a loss every month (B2:B7 show profit as negative numbers). Find the worst…
- Invoice dates are stored as date numbers in B2:B6. Find the date number of the earliest…
- January sales are in B2:B7 and February sales in C2:C7. Find the biggest drop (the most…
- Days late are in B2:B7. The late fee is 25 for each day late, but never more than 500.…
All practice questions · Excel exercises · Interview prep · Cheat sheet