Which of the following functions returns the number in the middle of a set of numbers?
A) COUNT
B) MEAN
C) MEDIAN
D) COUNTA

Question

Quizplus · Accepted Answer

The median is the number that falls exactly in the middle of a dataset. The mean (B) is the average of all the numbers in a dataset, while the count (A) function counts the number of cells in a range that contain numbers. The COUNTA function (D) counts the number of cells in a range that are not blank. Therefore, C is the best choice for finding the number in the middle of a set of numbers.

Which of the Following Functions Returns the Number in the Middle