Skip to main content

Analyse deposits with MAX, MIN and LARGE

100%
MAXMINLARGE

MAX and MIN answer the easiest questions about a numerical column: what is the largest value and what is the smallest? LARGE asks for a ranked position, such as the second-largest.

Using the whole data range matters more than the function names. A result can look reasonable even when the range stops one row early, so check the first and last rows before trusting a summary.

Fill E2:E5 with the largest deposit, the smallest, the second largest and the third largest.

The grid for this exercise is part of the paid half.

Everything above is yours to read either way. 46 exercises stay free with a profile.

Adapted from Excel Beginners Practice Lab by Muhammad Auwal Abdulaziz (MIT).