Course
SMALL, LARGE and MEDIAN practice exercises
Five exercises, from the second-best sale to comparing carriers with the median. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Read the SMALL, LARGE and MEDIAN tutorial
Exercise 1 of 5
Find the second-best sale
This quarter’s sales per salesperson are in B2:B9. In E2, return the second highest amount with LARGE.
| Salesperson | Sales ($) | |||
| Olivia Reed | 18,450 | Second-best sale | ||
| James Carter | 22,300 | |||
| Sofia Patel | 15,780 | |||
| Liam Brooks | 26,900 | |||
| Emma Hughes | 19,640 | |||
| Noah Bennett | 24,150 | |||
| Ava Collins | 12,870 | |||
| Ethan Price | 21,030 |