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

Quiz =MEDIAN — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

Which formula is a valid example of =MEDIAN?

Question 2 of 15 2/15

Is =MEDIAN volatile?

Question 3 of 15 3/15

What is the output type of =MEDIAN?

Question 4 of 15 4/15

Which function is NOT related to =MEDIAN?

Question 5 of 15 5/15

How many arguments does =MEDIAN have in total?

Question 6 of 15 6/15

How many optional arguments does =MEDIAN have?

Question 7 of 15 7/15

In =MEDIAN, which is argument #1?

Question 8 of 15 8/15

Does =MEDIAN return a dynamic array?

Question 9 of 15 9/15

Which statement about =MEDIAN is correct?

Question 10 of 15 10/15

How many required arguments does =MEDIAN have?

Question 11 of 15 11/15

Which is the correct syntax of =MEDIAN?

Question 12 of 15 12/15

Which category does =MEDIAN belong to?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

Since which Excel version is =MEDIAN available?

Question 15 of 15 15/15

Is argument “number1” required in =MEDIAN?

Click a question to see the answer.

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

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

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

2. Is =MEDIAN volatile?

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

Explanation: MEDIAN is not volatile.

3. What is the output type of =MEDIAN?

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

Explanation: Output is “Number”.

4. Which function is NOT related to =MEDIAN?

A. MAX
B. CEILING.MATH ✓
C. AVERAGE
D. MIN

Explanation: “CEILING.MATH” is not related to MEDIAN.

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

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

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

6. How many optional arguments does =MEDIAN have?

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

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

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

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

Explanation: Argument #1 is “number1”.

8. Does =MEDIAN return a dynamic array?

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

Explanation: MEDIAN does not spill.

9. Which statement about =MEDIAN is correct?

A. Requires add-in
B. Text is always ignored
C. 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. ✓
D. Arguments that are error values or text that cannot be translated into numbers cause errors.

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.

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).

11. Which is the correct syntax of =MEDIAN?

A. MEDIAN(number1, [number2], ...)
B. =MEDIAN(number1, [number2], ..., 0)
C. =MEDIAN(number1, [number2], ...) ✓
D. =AVERAGE(number1, [number2], ...)

Explanation: Correct syntax: =MEDIAN(number1, [number2], ...)

12. Which category does =MEDIAN belong to?

A. Logical
B. Lookup & Reference
C. Math & Trig
D. Statistical ✓

Explanation: Category is “Statistical”.

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

A. Number ✓
B. Reference
C. Mixed
D. Date

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

14. Since which Excel version is =MEDIAN available?

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

Explanation: Version: “All versions”.

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

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

Explanation: “number1” is required.