What function would you use to find the average of a set of numbers?

What function would you use to find the average of a set of numbers?

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

Answer: (B)

To find the average of a set of numbers in Excel, the AVERAGE function is specifically designed for this purpose. It calculates the mean by summing all the values in a specified range and then dividing by the total number of values. This function is straightforward and intuitive, making it easy for users to determine the central tendency of a given set of data. The other functions serve different purposes: SUM adds all the numbers together, COUNT tallies the number of entries but does not compute an average, and MEDIAN finds the middle value in a set of numbers rather than the average. Each of these functions has its own applications, but when the goal is to calculate an average, AVERAGE is the precise choice.

To find the average of a set of numbers in Excel, the AVERAGE function is specifically designed for this purpose. It calculates the mean by summing all the values in a specified range and then dividing by the total number of values. This function is straightforward and intuitive, making it easy for users to determine the central tendency of a given set of data.

The other functions serve different purposes: SUM adds all the numbers together, COUNT tallies the number of entries but does not compute an average, and MEDIAN finds the middle value in a set of numbers rather than the average. Each of these functions has its own applications, but when the goal is to calculate an average, AVERAGE is the precise choice.