Statistical =MEDIAN(number1, [number2], ...)

Quiz =MEDIAN — 10 Questions

10 quiz questions about =MEDIAN — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← MEDIAN ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

In =MEDIAN, which is argument #1?

Question 2 of 10 2/10

Which function is related to =MEDIAN?

Question 3 of 10 3/10

Which statement about =MEDIAN is correct?

Question 4 of 10 4/10

Since which Excel version is =MEDIAN available?

Question 5 of 10 5/10

What is the output type of =MEDIAN?

Question 6 of 10 6/10

How many optional arguments does =MEDIAN have?

Question 7 of 10 7/10

Does =MEDIAN return a dynamic array?

Question 8 of 10 8/10

How many arguments does =MEDIAN have in total?

Question 9 of 10 9/10

Which formula is a valid example of =MEDIAN?

Question 10 of 10 10/10

Which function is NOT related to =MEDIAN?

Click a question to see the answer.

1. In =MEDIAN, which is argument #1?

A. value
B. lookup_value
C. range
D. number1 ✓

Explanation: Argument #1 is “number1”.

2. Which function is related to =MEDIAN?

A. FUNC376
B. AVERAGE ✓
C. ISREF
D. SUMPRODUCT

Explanation: “AVERAGE” is related to MEDIAN.

3. Which statement about =MEDIAN is correct?

A. Average which is the arithmetic mean, and is calculated by adding a group of numbers and then dividing by the count of those numbers. For example, the average of 2, 3, 3, 5, 7, and 10 is 30 divided by 6, which is 5.
B. If there is an even number of numbers in the set, then MEDIAN calculates the average of the two numbers in the middle. See the second formula in the example. ✓
C. Mode which is the most frequently occurring number in a group of numbers. For example, the mode of 2, 3, 3, 5, 7, and 10 is 3.
D. Output is always a dynamic array

Explanation: Correct: If there is an even number of numbers in the set, then MEDIAN calculates the average of the two numbers in the middle. See the second formula in the example.

4. Since which Excel version is =MEDIAN available?

A. All versions ✓
B. Excel 365
C. Excel 2007 (Compatibility)
D. Excel 2019

Explanation: Version: “All versions”.

5. What is the output type of =MEDIAN?

A. Logical
B. Value
C. Array
D. Number ✓

Explanation: Output is “Number”.

6. How many optional arguments does =MEDIAN have?

A. 0 ✓
B. 2
C. —
D. 1

Explanation: =MEDIAN has 1 required, 0 optional (1 total).

7. Does =MEDIAN return a dynamic array?

A. —
B. Yes
C. No
D. No ✓

Explanation: MEDIAN does not spill.

8. How many arguments does =MEDIAN have in total?

A. 4
B. 1 ✓
C. 3
D. 2

Explanation: =MEDIAN has 1 required, 0 optional (1 total).

9. Which formula is a valid example of =MEDIAN?

A. =MEDIAN(A2:A6, 0)
B. =MEDIAN(A2:A6) ✓
C. MEDIAN(A2:A6)
D. =AVERAGE(A2:A6)

Explanation: Correct example: =MEDIAN(A2:A6)

10. Which function is NOT related to =MEDIAN?

A. AVERAGE
B. MDETERM ✓
C. MAX
D. MIN

Explanation: “MDETERM” is not related to MEDIAN.