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 use case fits =MEDIAN?

Question 2 of 10 2/10

How many arguments does =MEDIAN have in total?

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

Does =MEDIAN return a dynamic array?

Question 6 of 10 6/10

Which function is NOT related to =MEDIAN?

Question 7 of 10 7/10

Which function is related to =MEDIAN?

Question 8 of 10 8/10

Which statement about =MEDIAN is correct?

Question 9 of 10 9/10

How many required arguments does =MEDIAN have?

Question 10 of 10 10/10

How many optional arguments does =MEDIAN have?

Click a question to see the answer.

1. Which use case fits =MEDIAN?

A. Descriptive Statistics ✓
B. Ranking & Top N
C. Data Cleaning
D. Loans & Installments

Explanation: Use case “Descriptive Statistics” fits MEDIAN.

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

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

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

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. Statistical ✓
B. Database
C. Financial
D. Logical

Explanation: Category is “Statistical”.

5. Does =MEDIAN return a dynamic array?

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

Explanation: MEDIAN does not spill.

6. Which function is NOT related to =MEDIAN?

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

Explanation: “IMSECH” is not related to MEDIAN.

7. Which function is related to =MEDIAN?

A. PRICE
B. ERF.PRECISE
C. AVERAGE ✓
D. CUBEMEMBERPROPERTY

Explanation: “AVERAGE” is related to MEDIAN.

8. 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. 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.
C. Volatile and recalculates every time
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. How many required arguments does =MEDIAN have?

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

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

10. How many optional arguments does =MEDIAN have?

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

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