MIN is a formula that will give a lowest value in a specified range.
MAX is a formula that will give a highest value in a specified range.
AVERAGE is a formula that will give an average value in a specified range.
Example:
=MIN(A1:A5) will return 1.
=MAX(A1:A5) will return 5.
=AVERAGE(A1:A5) will return 3.