Course
MIN and MAX practice exercises
Five exercises, from finding the highest order to capping a bonus copied down a column. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 5
Find the highest order
The amounts of this month’s orders are in B2:B9. In E2, return the highest amount with MAX.
| Order | Amount ($) | |||
| #4101 | 1,240 | Highest order | ||
| #4102 | 385 | |||
| #4103 | 2,760 | |||
| #4104 | 918 | |||
| #4105 | 1,575 | |||
| #4106 | 642 | |||
| #4107 | 2,190 | |||
| #4108 | 1,033 |