Excel MIN 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 lowest 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: 67
How it works
Explanation: MIN ignores text in a range, so the Absent entries are skipped.
Syntax: =MIN(B2:B8)
Only the numbers 72, 88, 91, 67 and 79 count. The lowest is 67.
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…
- 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…
- Using the sales in B2:B8, find the gap between the best and the weakest sale. Put it in…
- 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