MIN and MAX
Exercise 1 of 4
In F2, find the highest score.
About this lesson
MIN and MAX find the smallest and largest values, and MAXIFS does it for matching rows only.
In this lesson
- In
F2, find the highest score. - In
F2, find the lowest score. - In
F2, work out the spread: the highest score minus the lowest. - In
F2, find the best score in class 7B.
Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.
fx
Type in F2 and press Enter to check.