Statistical =QUARTILE.INC(array,quart)

Quiz =QUARTILE.INC — 10 Questions

10 quiz questions about =QUARTILE.INC — test syntax, arguments, examples & errors!

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

← QUARTILE.INC ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the type of argument “quart” in =QUARTILE.INC?

Question 2 of 10 2/10

Does =QUARTILE.INC return a dynamic array?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Since which Excel version is =QUARTILE.INC available?

Question 5 of 10 5/10

Which is the correct syntax of =QUARTILE.INC?

Question 6 of 10 6/10

Which function is NOT related to =QUARTILE.INC?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

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

Question 9 of 10 9/10

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

Question 10 of 10 10/10

How many required arguments does =QUARTILE.INC have?

Click a question to see the answer.

1. What is the type of argument “quart” in =QUARTILE.INC?

A. Text
B. Number ✓
C. Logical
D. Date

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

2. Does =QUARTILE.INC return a dynamic array?

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

Explanation: QUARTILE.INC does not spill.

3. In =QUARTILE.INC, which is argument #1?

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

Explanation: Argument #1 is “array”.

4. Since which Excel version is =QUARTILE.INC available?

A. Excel 2007 (Compatibility)
B. Excel 2010 ✓
C. Excel 2019
D. Excel 365

Explanation: Version: “Excel 2010”.

5. Which is the correct syntax of =QUARTILE.INC?

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

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

6. Which function is NOT related to =QUARTILE.INC?

A. MIN
B. IMPOWER ✓
C. MAX
D. MEDIAN

Explanation: “IMPOWER” is not related to QUARTILE.INC.

7. Is argument “array” required in =QUARTILE.INC?

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

Explanation: “array” is required.

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

A. Only works in old versions
B. Text is always ignored
C. Requires add-in
D. Correct the input value ✓

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

9. Which formula is a valid example of =QUARTILE.INC?

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

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

10. How many required arguments does =QUARTILE.INC have?

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

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