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

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

Question 3 of 10 3/10

Which statement about =QUARTILE is correct?

Question 4 of 10 4/10

Is =QUARTILE volatile?

Question 5 of 10 5/10

Which function is NOT related to =QUARTILE?

Question 6 of 10 6/10

Which formula is a valid example of =QUARTILE?

Question 7 of 10 7/10

Which category does =QUARTILE belong to?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

What usually causes #NUM! in =QUARTILE?

Question 10 of 10 10/10

How many arguments does =QUARTILE have in total?

Click a question to see the answer.

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

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

Explanation: Argument #2 is “quart”.

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

A. Correct the input value ✓
B. Text is always ignored
C. Output is always a dynamic array
D. Select entire column for best performance

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

3. Which statement about =QUARTILE is correct?

A. If quart is not an integer, it is truncated.
B. Output is always a dynamic array
C. Volatile and recalculates every time
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.

4. Is =QUARTILE volatile?

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

Explanation: QUARTILE is not volatile.

5. Which function is NOT related to =QUARTILE?

A. PERCENTILE
B. LOWER ✓
C. QUARTILE-EXC
D. MEDIAN

Explanation: “LOWER” is not related to QUARTILE.

6. Which formula is a valid example of =QUARTILE?

A. QUARTILE(A2:A9,1)
B. =MEDIAN(A2:A9,1)
C. =QUARTILE(A2:A9,1, 0)
D. =QUARTILE(A2:A9,1) ✓

Explanation: Correct example: =QUARTILE(A2:A9,1)

7. Which category does =QUARTILE belong to?

A. Lookup & Reference
B. Math & Trig
C. Engineering
D. Compatibility ✓

Explanation: Category is “Compatibility”.

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

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

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

9. 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. Volatile and recalculates every time
C. Only works in old versions
D. Text is always ignored

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

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

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

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