Which of the following functions adds cell values together and divides the result by the number of values? 1. MIN 2. MAX 3. AVERAGE 4. COUNT

Break Down the Problem

1. Identify the functions listed: MIN, MAX, AVERAGE, COUNT.
2. Determine the purpose of each function regarding cell values.

Relevant Concepts

1. MIN: Returns the smallest value from a set of values.
2. MAX: Returns the largest value from a set of values.
3. AVERAGE: Calculates the sum of a set of values and divides by the number of values in the set.
4. COUNT: Counts the number of cells that contain numeric values.

Analysis and Detail

• The question specifically asks for a function that combines values by adding them and then dividing by the count of those values.
• Among the functions provided, only AVERAGE performs this operation.

Verify and Summarize

• AVERAGE correctly adds up all the values and divides the total by the number of values, which matches the requirement provided in the question.

Final Answer

The correct function is 3. AVERAGE.