Which function computes the mean of numeric data in spreadsheets?

Which function computes the mean of numeric data in spreadsheets?

• A. SUM
• B. AVERAGE
• C. MAX
• D. MIN

Answer: (B)

The mean of a set of numbers is found by adding them up and dividing by how many numbers there are. In spreadsheets, the AVERAGE function performs this calculation, taking a range of numeric data and returning the average. It counts only numeric entries, ignoring blanks and text so only actual numbers affect the result. For example, with numbers 2, 4, and 6, AVERAGE gives (2 + 4 + 6) / 3 = 4. Other functions perform different tasks: SUM adds all numbers together, MAX returns the largest value, and MIN returns the smallest.

The mean of a set of numbers is found by adding them up and dividing by how many numbers there are. In spreadsheets, the AVERAGE function performs this calculation, taking a range of numeric data and returning the average. It counts only numeric entries, ignoring blanks and text so only actual numbers affect the result. For example, with numbers 2, 4, and 6, AVERAGE gives (2 + 4 + 6) / 3 = 4. Other functions perform different tasks: SUM adds all numbers together, MAX returns the largest value, and MIN returns the smallest.