AVERAGE

Definition: AVERAGE is a function that returns the arithmetic mean of a list of numbers.

Syntax: =AVERAGE(number1, [number2], …)

Situation: This formula is suitable when you need to find the average of a list of numbers.

Example: If you have a list of test scores in cells A1 to A10, the average score can be found using the formula =AVERAGE(A1:A10). If the scores are [75, 85, 90, 70, 80, 85, 80, 75, 90, 80], the average score is 80.