Compatibility =PERCENTILE(array,k)

Quiz =PERCENTILE — 10 Questions

10 quiz questions about =PERCENTILE — test syntax, arguments, examples & errors!

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

← PERCENTILE ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What usually causes #VALUE! in =PERCENTILE?

Question 2 of 10 2/10

Which function is NOT related to =PERCENTILE?

Question 3 of 10 3/10

Which use case fits =PERCENTILE?

Question 4 of 10 4/10

Which statement about =PERCENTILE is correct?

Question 5 of 10 5/10

Is argument “array” required in =PERCENTILE?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Is argument “k” required in =PERCENTILE?

Question 8 of 10 8/10

Which category does =PERCENTILE belong to?

Question 9 of 10 9/10

In =PERCENTILE, which is argument #1?

Question 10 of 10 10/10

How many arguments does =PERCENTILE have in total?

Click a question to see the answer.

1. What usually causes #VALUE! in =PERCENTILE?

A. Requires add-in
B. Only works in old versions
C. Text is always ignored
D. If k is non-numeric, PERCENTILE returns the #VALUE! error value. ✓

Explanation: If k is non-numeric, PERCENTILE returns the #VALUE! error value. — Fix: برای k یک مقدار عددی بین 0 تا 1 وارد کنید.

2. Which function is NOT related to =PERCENTILE?

A. MEDIAN
B. QUARTILE
C. PERCENTILE-EXC
D. PERCENTRANK.INC ✓

Explanation: “PERCENTRANK.INC” is not related to PERCENTILE.

3. Which use case fits =PERCENTILE?

A. Conditional Formatting & Validation
B. Ranking & Top N ✓
C. Probability & Hypothesis Testing
D. External Data, Web & Cube

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

4. Which statement about =PERCENTILE is correct?

A. Requires add-in
B. Select entire column for best performance
C. 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. For more information about the new functions, see PERCENTILE.EXC function and PERCENTILE.INC function. ✓
D. Only works in old versions

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. For more information about the new functions, see PERCENTILE.EXC function and PERCENTILE.INC function.

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

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

Explanation: “array” is required.

6. What is the type of argument “array” in =PERCENTILE?

A. Logical
B. Mixed
C. Number
D. Array ✓

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

7. Is argument “k” required in =PERCENTILE?

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

Explanation: “k” is required.

8. Which category does =PERCENTILE belong to?

A. Financial
B. Statistical
C. Compatibility ✓
D. Logical

Explanation: Category is “Compatibility”.

9. In =PERCENTILE, which is argument #1?

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

Explanation: Argument #1 is “array”.

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

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

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