MAX practice exercises
The largest number. Work through these on the table below, then check each answer.
Practise interactively Type formulas into a live sheet with instant feedback. Free.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 5801 | East | Omar | 4 | 30 | 120 |
| 3 | 5802 | East | Raj | 3 | 9 | 27 |
| 4 | 5803 | North | Omar | 7 | 12 | 84 |
| 5 | 5804 | North | Ana | 8 | 60 | 480 |
| 6 | 5805 | North | Ana | 3 | 15 | 45 |
| 7 | 5806 | East | Omar | 7 | 45 | 315 |
| 8 | 5807 | South | Ana | 6 | 9 | 54 |
| 9 | 5808 | South | Lena | 1 | 24 | 24 |
Find the largest Revenue on any order.
Show answer
=MAX(F2:F9)→ 480Find the largest Units on any order.
Show answer
=MAX(D2:D9)→ 8
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 5101 | East | Maya | 5 | 30 | 150 |
| 3 | 5102 | North | Maya | 6 | 60 | 360 |
| 4 | 5103 | North | Omar | 4 | 15 | 60 |
| 5 | 5104 | West | Ines | 4 | 30 | 120 |
| 6 | 5105 | West | Maya | 3 | 12 | 36 |
| 7 | 5106 | North | Theo | 7 | 9 | 63 |
| 8 | 5107 | South | Theo | 5 | 45 | 225 |
| 9 | 5108 | East | Maya | 7 | 9 | 63 |
Find the largest Units on any order.
Show answer
=MAX(D2:D9)→ 7Find the largest Revenue on any order.
Show answer
=MAX(F2:F9)→ 360
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 6701 | West | Ines | 8 | 15 | 120 |
| 3 | 6702 | East | Ana | 9 | 9 | 81 |
| 4 | 6703 | East | Ines | 7 | 60 | 420 |
| 5 | 6704 | South | Omar | 5 | 45 | 225 |
| 6 | 6705 | South | Raj | 9 | 30 | 270 |
| 7 | 6706 | West | Ines | 4 | 18 | 72 |
| 8 | 6707 | East | Omar | 6 | 60 | 360 |
| 9 | 6708 | West | Ana | 5 | 12 | 60 |
Find the largest Units on any order.
Show answer
=MAX(D2:D9)→ 9Find the largest Revenue on any order.
Show answer
=MAX(F2:F9)→ 420
New to MAX? Read the MAX guide first: syntax, a worked example and common mistakes.