BeginnerStatistical Functions
Find the largest and smallest order
Identify the extremes in a column of values.
MAX · MIN
4 min10 points
MIN
Returns the smallest number in a range.
Syntax
MIN(number1, [number2], ...)
Statistical Functions.
Practise MIN1 interactive exercise, free, no account needed
A worked example
=MIN(C2:C9)
Returns $890
Scans the eight order values and returns the smallest — Fairmont's $890 order.
Where it goes wrong
Text and blanks are ignored, so a column of numbers stored as text returns 0.
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
Practise MIN
Knowing what a function does and being able to write it from memory are different skills. These close the gap.