Compatibility =QUARTILE(array,quart)

Quiz =QUARTILE — 15 Questions

15 quiz questions about =QUARTILE — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← QUARTILE ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which is the correct syntax of =QUARTILE?

Question 2 of 15 2/15

Which use case fits =QUARTILE?

Question 3 of 15 3/15

What is the type of argument “array” in =QUARTILE?

Question 4 of 15 4/15

What is the fix for #NUM! in =QUARTILE?

Question 5 of 15 5/15

Which statement about =QUARTILE is correct?

Question 6 of 15 6/15

What usually causes #NUM! in =QUARTILE?

Question 7 of 15 7/15

Which category does =QUARTILE belong to?

Question 8 of 15 8/15

Does =QUARTILE return a dynamic array?

Question 9 of 15 9/15

Is argument “array” required in =QUARTILE?

Question 10 of 15 10/15

What is the output type of =QUARTILE?

Question 11 of 15 11/15

In =QUARTILE, which is argument #1?

Question 12 of 15 12/15

Is argument “quart” required in =QUARTILE?

Question 13 of 15 13/15

Which function is related to =QUARTILE?

Question 14 of 15 14/15

How many optional arguments does =QUARTILE have?

Question 15 of 15 15/15

How many arguments does =QUARTILE have in total?

Click a question to see the answer.

1. Which is the correct syntax of =QUARTILE?

A. QUARTILE(array,quart)
B. =QUARTILE(array,quart, 0)
C. =QUARTILE(array,quart) ✓
D. =MEDIAN(array,quart)

Explanation: Correct syntax: =QUARTILE(array,quart)

2. Which use case fits =QUARTILE?

A. Ranking & Top N ✓
B. Error Handling
C. Financial Calculations
D. Depreciation

Explanation: Use case “Ranking & Top N” fits QUARTILE.

3. What is the type of argument “array” in =QUARTILE?

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

Explanation: Type of “array” is “Array”.

4. What is the fix for #NUM! in =QUARTILE?

A. Output is always a dynamic array
B. Requires add-in
C. Correct the input value ✓
D. Only works in old versions

Explanation: If array is empty, QUARTILE returns the #NUM! error value. If quart < 0 or if quart > 4, QUARTILE returns the #NUM! error value. — Fix: Correct the input value

5. Which statement about =QUARTILE is correct?

A. MIN, MEDIAN, and MAX return the same value as QUARTILE when quart is equal to 0 (zero), 2, and 4, respectively.
B. If quart is not an integer, it is truncated.
C. Only works in old versions
D. This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. ✓

Explanation: Correct: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel.

6. What usually causes #NUM! in =QUARTILE?

A. If array is empty, QUARTILE returns the #NUM! error value. If quart < 0 or if quart > 4, QUARTILE returns the #NUM! error value. ✓
B. Select entire column for best performance
C. Text is always ignored
D. Volatile and recalculates every time

Explanation: If array is empty, QUARTILE returns the #NUM! error value. If quart < 0 or if quart > 4, QUARTILE returns the #NUM! error value. — Fix: Correct the input value

7. Which category does =QUARTILE belong to?

A. Engineering
B. Date & Time
C. Financial
D. Compatibility ✓

Explanation: Category is “Compatibility”.

8. Does =QUARTILE return a dynamic array?

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

Explanation: QUARTILE does not spill.

9. Is argument “array” required in =QUARTILE?

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

Explanation: “array” is required.

10. What is the output type of =QUARTILE?

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

Explanation: Output is “Number”.

11. In =QUARTILE, which is argument #1?

A. quart
B. array ✓
C. criteria
D. lookup_value

Explanation: Argument #1 is “array”.

12. Is argument “quart” required in =QUARTILE?

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

Explanation: “quart” is required.

13. Which function is related to =QUARTILE?

A. MAXIFS
B. MEDIAN ✓
C. AGGREGATE
D. FORECAST

Explanation: “MEDIAN” is related to QUARTILE.

14. How many optional arguments does =QUARTILE have?

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

Explanation: =QUARTILE has 2 required, 0 optional (2 total).

15. How many arguments does =QUARTILE have in total?

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

Explanation: =QUARTILE has 2 required, 0 optional (2 total).