MIN and MAX

Identify the smallest and largest values in a dataset.

Practical example

=MAX(D2:D50)

Identify the source cells, apply the smallest reliable formula or tool, and test the result with changed data.

Continue into guided Excel practice