Compatibility =QUARTILE(array,quart)

Quiz =QUARTILE — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

In =QUARTILE, which is argument #2?

Question 2 of 10 2/10

In =QUARTILE, which is argument #1?

Question 3 of 10 3/10

Is argument “quart” required in =QUARTILE?

Question 4 of 10 4/10

What usually causes #NUM! in =QUARTILE?

Question 5 of 10 5/10

Is argument “array” required in =QUARTILE?

Question 6 of 10 6/10

How many required arguments does =QUARTILE have?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Which statement about =QUARTILE is correct?

Question 10 of 10 10/10

Which use case fits =QUARTILE?

Click a question to see the answer.

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

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

Explanation: Argument #2 is “quart”.

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

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

Explanation: Argument #1 is “array”.

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

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

Explanation: “quart” is required.

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

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

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. Is argument “array” required in =QUARTILE?

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

Explanation: “array” is required.

6. How many required arguments does =QUARTILE have?

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

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

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

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

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

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

A. Requires add-in
B. Correct the input value ✓
C. Output is always a dynamic array
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

9. Which statement about =QUARTILE is correct?

A. Only works in old versions
B. 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. ✓
C. Output is always a dynamic array
D. Requires add-in

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.

10. Which use case fits =QUARTILE?

A. Ranking & Top N ✓
B. Scientific & Unit Conversion
C. Workdays & Due Dates
D. Rounding & Numeric

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