In Excel, how do you find the annual average?

In Excel, how do you find the annual average?

• A. AVERAGE(letter#:letter#)
• B. SUM(letter#:letter#)
• C. MIN(letter#:letter#)
• D. COUNT(letter#:letter#)

Answer: (A)

Calculating the annual average uses the AVERAGE function, which computes the mean of a set of numbers. For yearly data, you point it to the 12 monthly values, for example =AVERAGE(B2:B13) if those cells hold January through December values. AVERAGE sums the numbers and divides by how many numeric entries there are, and it ignores blanks and text. The other options perform different tasks: SUM adds all the numbers to a total, MIN finds the smallest value in the range, and COUNT tells you how many numeric entries exist (not their average). So the AVERAGE function is the one that gives you the annual average.

Calculating the annual average uses the AVERAGE function, which computes the mean of a set of numbers. For yearly data, you point it to the 12 monthly values, for example =AVERAGE(B2:B13) if those cells hold January through December values. AVERAGE sums the numbers and divides by how many numeric entries there are, and it ignores blanks and text.

The other options perform different tasks: SUM adds all the numbers to a total, MIN finds the smallest value in the range, and COUNT tells you how many numeric entries exist (not their average). So the AVERAGE function is the one that gives you the annual average.