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

Does =MEDIAN return a dynamic array?

Question 2 of 10 2/10

Which function is NOT related to =MEDIAN?

Question 3 of 10 3/10

Is argument “number1” required in =MEDIAN?

Question 4 of 10 4/10

Which category does =MEDIAN belong to?

Question 5 of 10 5/10

What is the type of argument “number1” in =MEDIAN?

Question 6 of 10 6/10

In =MEDIAN, which is argument #1?

Question 7 of 10 7/10

Which formula is a valid example of =MEDIAN?

Question 8 of 10 8/10

Which statement about =MEDIAN is correct?

Question 9 of 10 9/10

Since which Excel version is =MEDIAN available?

Question 10 of 10 10/10

How many required arguments does =MEDIAN have?

Click a question to see the answer.

1. Does =MEDIAN return a dynamic array?

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

Explanation: MEDIAN does not spill.

2. Which function is NOT related to =MEDIAN?

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

Explanation: “COMBIN” is not related to MEDIAN.

3. Is argument “number1” required in =MEDIAN?

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

Explanation: “number1” is required.

4. Which category does =MEDIAN belong to?

A. Date & Time
B. Statistical ✓
C. Cube
D. Database

Explanation: Category is “Statistical”.

5. What is the type of argument “number1” in =MEDIAN?

A. Text
B. Date
C. Number ✓
D. Value

Explanation: Type of “number1” is “Number”.

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

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

Explanation: Argument #1 is “number1”.

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

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

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

8. Which statement about =MEDIAN is correct?

A. Output is always a dynamic array
B. Text is always ignored
C. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
D. 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. ✓

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.

9. Since which Excel version is =MEDIAN available?

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

Explanation: Version: “All versions”.

10. How many required arguments does =MEDIAN have?

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

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