Which formula would you use to calculate the average of a range of cells?

Which formula would you use to calculate the average of a range of cells?

• A. SUM()
• B. AVERAGE()
• C. COUNT()
• D. MEDIAN()

Answer: (B)

The formula used to calculate the average of a range of cells is AVERAGE(). This function takes a set of numbers or a range of cells as arguments and computes their arithmetic mean, which is the sum of the numbers divided by the count of those numbers. This is particularly useful in various data analysis scenarios where you want to summarize a dataset by finding the typical value. The AVERAGE() function is straightforward and efficient, making it the go-to choice when you need to find the average, as it directly serves that purpose. In contrast, the other functions serve different roles: SUM() adds together all the specified values, COUNT() tallies the number of cells containing numbers, and MEDIAN() calculates the middle value in a set of data. Therefore, none of these alternatives address the specific need to compute an average as directly as AVERAGE() does.

The formula used to calculate the average of a range of cells is AVERAGE(). This function takes a set of numbers or a range of cells as arguments and computes their arithmetic mean, which is the sum of the numbers divided by the count of those numbers. This is particularly useful in various data analysis scenarios where you want to summarize a dataset by finding the typical value.

The AVERAGE() function is straightforward and efficient, making it the go-to choice when you need to find the average, as it directly serves that purpose. In contrast, the other functions serve different roles: SUM() adds together all the specified values, COUNT() tallies the number of cells containing numbers, and MEDIAN() calculates the middle value in a set of data. Therefore, none of these alternatives address the specific need to compute an average as directly as AVERAGE() does.