Excel MAX Practice Question: Exam marks are in B2:B8. Two students were Absent (typed as text). Find the…
The question
Exam marks are in B2:B8. Two students were Absent (typed as text). Find the top mark. Put it in D2.
The data
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Student | Marks | Result | |
| 2 | Anil | 72 | ? | |
| 3 | Bhavna | 88 | ||
| 4 | Chirag | Absent | ||
| 5 | Deepa | 91 | ||
| 6 | Esha | 67 | ||
| 7 | Farid | Absent | ||
| 8 | Gita | 79 |
The yellow cell is where your answer goes.
Show answer
Answer in D2: 91
How it works
Explanation: MAX ignores text in a range, so the Absent entries do not cause an error.
Syntax: =MAX(B2:B8)
Only the numbers 72, 88, 91, 67 and 79 count. The top mark is 91.
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…
- 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…
- Using the sales in B2:B8, show Meera's sales (B4) as a fraction of the best sale. Round…
- 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