Excel MAX Practice Question: Using the sales in B2:B8, show Meera's sales (B4) as a fraction of the best…
The question
Using the sales in B2:B8, show Meera's sales (B4) as a fraction of the best sale. Round to 2 decimals. 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: 0.63
How it works
Explanation: Comparing a value with the maximum is a common way to score performance.
Syntax: =ROUND(B4/MAX(B2:B8),2)
38750 / 61400 = 0.63.
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 →MAX syntax
=MAX(number1, [number2], ...)
Returns the largest number in a set. MAX is used in data analysis work to summarize or test patterns across a data set. Full MAX guide.
More MAX practice questions
- A sales team's monthly sales are in B2:B8. Find the highest sale. Put it in D2.
- The daily temperature (in °C) for a week is in B2:B8. What was the hottest day's…
- Q1 sales are in B2:B6 and Q2 sales are in C2:C6. Find the single highest figure across…
- Exam marks are in B2:B8. Two students were Absent (typed as text). Find the top mark.…
- A shop made a loss every month (B2:B7 show profit as negative numbers). Find the best…
- Invoice dates are stored as date numbers in B2:B6. Find the date number of the latest…
- January sales are in B2:B7 and February sales in C2:C7. Find the biggest increase from…
- Daily sales for one week are in B2:B8. Find the highest sales figure of the week. Put it…
All practice questions · Excel exercises · Interview prep · Cheat sheet