AVERAGE | =AVERAGE(number1, [number2], …) | Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references that contain numbers |
MIN | =MIN(number1, [number2], …) | Returns the smallest number in a set of values. Ignores logical values and text |
MAX | =MAX(number1, [number2], …) | Returns the largest number in a set of values. Ignores logical values and text |
MEDIAN | =MEDIAN(number1, [number2], …) | Returns the median, or the number in the middle of the set of given numbers |
MODE | =MODE(number1, [number2], …) | Returns the most frequently occurring, or repetative value, in an array or range of data |