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

Which statement about =QUARTILE is correct?

Question 2 of 10 2/10

How many optional arguments does =QUARTILE have?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

How many required arguments does =QUARTILE have?

Question 5 of 10 5/10

Is argument “array” required in =QUARTILE?

Question 6 of 10 6/10

Is argument “quart” required in =QUARTILE?

Question 7 of 10 7/10

Which function is NOT related to =QUARTILE?

Question 8 of 10 8/10

Which use case fits =QUARTILE?

Question 9 of 10 9/10

Which is the correct syntax of =QUARTILE?

Question 10 of 10 10/10

Which category does =QUARTILE belong to?

Click a question to see the answer.

1. Which statement about =QUARTILE is correct?

A. 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. ✓
B. Select entire column for best performance
C. MIN, MEDIAN, and MAX return the same value as QUARTILE when quart is equal to 0 (zero), 2, and 4, respectively.
D. Text is always ignored

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.

2. How many optional arguments does =QUARTILE have?

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

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

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

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

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

4. How many required arguments does =QUARTILE have?

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

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

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

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

Explanation: “array” is required.

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

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

Explanation: “quart” is required.

7. Which function is NOT related to =QUARTILE?

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

Explanation: “LOG” is not related to QUARTILE.

8. Which use case fits =QUARTILE?

A. Probability & Hypothesis Testing
B. Forecasting & Trends
C. Securities & Bonds
D. Ranking & Top N ✓

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

9. Which is the correct syntax of =QUARTILE?

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

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

10. Which category does =QUARTILE belong to?

A. Information
B. Date & Time
C. Compatibility ✓
D. Lookup & Reference

Explanation: Category is “Compatibility”.