Which function would you use to calculate the average of a range of numbers?

The function used to calculate the average of a range of numbers in Excel is AVERAGE(). This function adds up all the numbers in the specified range and then divides that sum by the total count of values in the range, resulting in the arithmetic mean.

For example, if you have a range of numbers from A1 to A10, the formula AVERAGE(A1:A10) would compute the average of those numbers, which is essential for statistical analysis, reporting, or simply summarizing data.

Using the SUM() function would only provide the total of the numbers, not the average. The MEDIAN() function is intended to find the middle value of a data set rather than the average. The COUNT() function counts the number of entries in a range but does not perform any calculations related to averages. Therefore, AVERAGE() is the appropriate and correct choice for determining the mean of a specified range of numbers.