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 category does =MEDIAN belong to?

Question 2 of 15 2/15

Does =MEDIAN return a dynamic array?

Question 3 of 15 3/15

Which formula is a valid example of =MEDIAN?

Question 4 of 15 4/15

Which statement about =MEDIAN is correct?

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

Which use case fits =MEDIAN?

Question 8 of 15 8/15

In =MEDIAN, which is argument #1?

Question 9 of 15 9/15

How many optional arguments does =MEDIAN have?

Question 10 of 15 10/15

Is =MEDIAN volatile?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

Since which Excel version is =MEDIAN available?

Question 13 of 15 13/15

Which function is related to =MEDIAN?

Question 14 of 15 14/15

What is the output type of =MEDIAN?

Question 15 of 15 15/15

Which is the correct syntax of =MEDIAN?

Click a question to see the answer.

1. Which category does =MEDIAN belong to?

A. Cube
B. Statistical ✓
C. Logical
D. Text

Explanation: Category is “Statistical”.

2. Does =MEDIAN return a dynamic array?

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

Explanation: MEDIAN does not spill.

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

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

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

4. Which statement about =MEDIAN is correct?

A. Median which is the middle number of a group of numbers; that is, half the numbers have values that are greater than the median, and half the numbers have values that are less than the median. For example, the median of 2, 3, 3, 5, 7, and 10 is 4.
B. 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.
C. Only works in old versions
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.

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

6. Which function is NOT related to =MEDIAN?

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

Explanation: “IMSINH” is not related to MEDIAN.

7. Which use case fits =MEDIAN?

A. Comparation
B. External Data, Web & Cube
C. Probability & Hypothesis Testing
D. Descriptive Statistics ✓

Explanation: Use case “Descriptive Statistics” fits MEDIAN.

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

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

Explanation: Argument #1 is “number1”.

9. How many optional arguments does =MEDIAN have?

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

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

10. Is =MEDIAN volatile?

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

Explanation: MEDIAN is not volatile.

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

A. Mixed
B. Text
C. Number ✓
D. Logical

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

12. Since which Excel version is =MEDIAN available?

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

Explanation: Version: “All versions”.

13. Which function is related to =MEDIAN?

A. AVERAGE ✓
B. ASIN
C. PRICE
D. COUPNUM

Explanation: “AVERAGE” is related to MEDIAN.

14. What is the output type of =MEDIAN?

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

Explanation: Output is “Number”.

15. 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], ...)