Name a common Excel function used to calculate the average of a range.

Name a common Excel function used to calculate the average of a range.

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

Answer: (A)

Calculating the average in Excel uses the AVERAGE function. This function takes a range of cells, adds all numeric values, and divides by how many numeric values exist, returning the arithmetic mean. For example, =AVERAGE(B2:B10) computes the mean of the numbers in that range. AVERAGE is the best choice when you want the typical value of a dataset. It ignores non-numeric cells, which helps when the range has blanks or text; if there are no numbers at all, Excel will return an error. Other common functions perform different tasks: SUM adds numbers, MAX finds the largest value, and CONCATENATE joins text strings.

Calculating the average in Excel uses the AVERAGE function. This function takes a range of cells, adds all numeric values, and divides by how many numeric values exist, returning the arithmetic mean. For example, =AVERAGE(B2:B10) computes the mean of the numbers in that range. AVERAGE is the best choice when you want the typical value of a dataset. It ignores non-numeric cells, which helps when the range has blanks or text; if there are no numbers at all, Excel will return an error. Other common functions perform different tasks: SUM adds numbers, MAX finds the largest value, and CONCATENATE joins text strings.