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

Which is the correct syntax of =MEDIAN?

Question 2 of 10 2/10

In =MEDIAN, which is argument #1?

Question 3 of 10 3/10

What is the output type of =MEDIAN?

Question 4 of 10 4/10

Which category does =MEDIAN belong to?

Question 5 of 10 5/10

Which formula is a valid example of =MEDIAN?

Question 6 of 10 6/10

Which function is NOT related to =MEDIAN?

Question 7 of 10 7/10

Is argument “number1” required in =MEDIAN?

Question 8 of 10 8/10

How many required arguments does =MEDIAN have?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Which statement about =MEDIAN is correct?

Click a question to see the answer.

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

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

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

Explanation: Argument #1 is “number1”.

3. What is the output type of =MEDIAN?

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

Explanation: Output is “Number”.

4. Which category does =MEDIAN belong to?

A. Compatibility
B. Statistical ✓
C. Text
D. Math & Trig

Explanation: Category is “Statistical”.

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

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

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

6. Which function is NOT related to =MEDIAN?

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

Explanation: “IF” is not related to MEDIAN.

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

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

Explanation: “number1” is required.

8. How many required arguments does =MEDIAN have?

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

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

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

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

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

10. Which statement about =MEDIAN is correct?

A. 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.
B. Logical values and text representations of numbers that you type directly into the list of arguments are counted.
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. 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.