PracticeExcelSign in
Excel practice exercises

MIN, MAX and LARGE practice exercises

Find the smallest and largest values in a range, and the second or third largest with LARGE.

Start the first exercise
  1. 1Find the fastest time with MINIn B8, use MIN to find the fastest (lowest) 100 m time in B2:B7.
  2. 2Find the best month with MAXPremiumIn E2, use MAX to find the highest sales figure in B2:B6.
  3. 3Find the runner-up with LARGEPremiumIn E2, use LARGE to find the second-highest score in B2:B7.
  4. 4The spread between highest and lowestPremiumIn E1, work out how far apart the quotes are, the highest minus the lowest. Subtract MIN from MAX in one formula.

Functions in this topic

Read the guide