The MEDIAN function finds ________.
A)the average value in a range of cells
B)the middle value in a range of cells
C)all numbers that correspond to an argument in the function
D)the one number that corresponds to an argument in the function

Question

Quizplus · Accepted Answer

The MEDIAN function finds the middle value in a range of cells. It is different from the AVERAGE function, which finds the average value in a range of cells. The function does not find all numbers that correspond to an argument or just one number that corresponds to an argument, as suggested in options C and D.

The MEDIAN Function Finds ________