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

In =MEDIAN, which is argument #1?

Question 2 of 15 2/15

Which category does =MEDIAN belong to?

Question 3 of 15 3/15

Which is the correct syntax of =MEDIAN?

Question 4 of 15 4/15

How many optional arguments does =MEDIAN have?

Question 5 of 15 5/15

How many arguments does =MEDIAN have in total?

Question 6 of 15 6/15

Which function is NOT related to =MEDIAN?

Question 7 of 15 7/15

What is the output type of =MEDIAN?

Question 8 of 15 8/15

Is =MEDIAN volatile?

Question 9 of 15 9/15

Which function is related to =MEDIAN?

Question 10 of 15 10/15

Which use case fits =MEDIAN?

Question 11 of 15 11/15

Is argument “number1” required in =MEDIAN?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

Since which Excel version is =MEDIAN available?

Question 14 of 15 14/15

Which statement about =MEDIAN is correct?

Question 15 of 15 15/15

Does =MEDIAN return a dynamic array?

Click a question to see the answer.

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

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

Explanation: Argument #1 is “number1”.

2. Which category does =MEDIAN belong to?

A. Text
B. Information
C. Statistical ✓
D. Web

Explanation: Category is “Statistical”.

3. Which is the correct syntax of =MEDIAN?

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

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

4. How many optional arguments does =MEDIAN have?

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

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

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

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

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

6. Which function is NOT related to =MEDIAN?

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

Explanation: “EXACT” is not related to MEDIAN.

7. What is the output type of =MEDIAN?

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

Explanation: Output is “Number”.

8. Is =MEDIAN volatile?

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

Explanation: MEDIAN is not volatile.

9. Which function is related to =MEDIAN?

A. BINOM.INV
B. REDUCE
C. TEXT
D. AVERAGE ✓

Explanation: “AVERAGE” is related to MEDIAN.

10. Which use case fits =MEDIAN?

A. Workdays & Due Dates
B. Loans & Installments
C. Conditional Logic
D. Descriptive Statistics ✓

Explanation: Use case “Descriptive Statistics” fits MEDIAN.

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

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

Explanation: “number1” is required.

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

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

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

13. Since which Excel version is =MEDIAN available?

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

Explanation: Version: “All versions”.

14. Which statement about =MEDIAN is correct?

A. Only works in old versions
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. Logical values and text representations of numbers that you type directly into the list of arguments are counted.
D. For a symmetrical distribution of a group of numbers, these three measures of central tendency are all the same. For a skewed distribution of a group of numbers, they can be different.

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.

15. Does =MEDIAN return a dynamic array?

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

Explanation: MEDIAN does not spill.