Which is an example of using the AVERAGE function on a range?

Which is an example of using the AVERAGE function on a range?

• A. =SUM(B2:B10)
• B. =MAX(B2:B10)
• C. =AVERAGE(B2:B10)
• D. =CONCATENATE(B2,B3)

Answer: (C)

The idea being tested is how to obtain the average of numbers in a range. The AVERAGE function takes a range of cells, sums all numeric values, and divides by how many numeric entries there are, giving the arithmetic mean. Using AVERAGE(B2:B10) applies that calculation to the values from B2 through B10, producing the mean for that set of data. Blank cells or text are ignored in the count, while zeros within the range still affect the average as zeros in the sum. The other formulas perform different tasks: SUM adds all numbers in the range, MAX finds the largest value, and CONCATENATE combines text from cells, none of which compute an average.

The idea being tested is how to obtain the average of numbers in a range. The AVERAGE function takes a range of cells, sums all numeric values, and divides by how many numeric entries there are, giving the arithmetic mean. Using AVERAGE(B2:B10) applies that calculation to the values from B2 through B10, producing the mean for that set of data. Blank cells or text are ignored in the count, while zeros within the range still affect the average as zeros in the sum. The other formulas perform different tasks: SUM adds all numbers in the range, MAX finds the largest value, and CONCATENATE combines text from cells, none of which compute an average.