MAX() and MIN()

MAX(data range) returns the largest number in a specified set of data.

MIN(data range) returns the Smallest number in a specified set of data.

MAX() can also be used as a counting tool (Explanation to be added later)