BeginnerStatistical Functions
Find the largest and smallest order
Identify the extremes in a column of values.
MAX · MIN
4 min10 points
MAX
Returns the largest number in a range.
Syntax
MAX(number1, [number2], ...)
Statistical Functions.
Practise MAX2 interactive exercises, free, no account needed
A worked example
=MAX(C2:C9)
Returns $4,250
Scans the eight order values and returns the largest — Delta Roofing's $4,250.
Where it goes wrong
Returns 0 rather than an error when a range contains no numbers at all.
What the exercises catch
Each of these is a wrong turn the practice exercises recognise and name. They are the misconceptions, not the answers.
- Reading the largest value off the screen works for eight rows. It does not work for eight thousand, which is the situation these functions exist for.Find the largest and smallest order
- That gives the number — 520 — but the review needs a name. The figure still has to be turned back into the campaign that produced it.Name the best-performing campaign
Practise MAX
Knowing what a function does and being able to write it from memory are different skills. These close the gap.