Compatibility =PERCENTILE(array,k)

Quiz =PERCENTILE — 15 Questions

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

Question 1 of 15 1/15

What is the output type of =PERCENTILE?

Question 2 of 15 2/15

Does =PERCENTILE return a dynamic array?

Question 3 of 15 3/15

In =PERCENTILE, which is argument #2?

Question 4 of 15 4/15

Which category does =PERCENTILE belong to?

Question 5 of 15 5/15

How many arguments does =PERCENTILE have in total?

Question 6 of 15 6/15

Which statement about =PERCENTILE is correct?

Question 7 of 15 7/15

Which function is related to =PERCENTILE?

Question 8 of 15 8/15

Which formula is a valid example of =PERCENTILE?

Question 9 of 15 9/15

Is =PERCENTILE volatile?

Question 10 of 15 10/15

Which is the correct syntax of =PERCENTILE?

Question 11 of 15 11/15

What usually causes #VALUE! in =PERCENTILE?

Question 12 of 15 12/15

Which use case fits =PERCENTILE?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

How many required arguments does =PERCENTILE have?

Question 15 of 15 15/15

Since which Excel version is =PERCENTILE available?

Click a question to see the answer.

1. What is the output type of =PERCENTILE?

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

Explanation: Output is “Number”.

2. Does =PERCENTILE return a dynamic array?

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

Explanation: PERCENTILE does not spill.

3. In =PERCENTILE, which is argument #2?

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

Explanation: Argument #2 is “k”.

4. Which category does =PERCENTILE belong to?

A. Statistical
B. Engineering
C. Information
D. Compatibility ✓

Explanation: Category is “Compatibility”.

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

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

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

6. Which statement about =PERCENTILE 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. For more information about the new functions, see PERCENTILE.EXC function and PERCENTILE.INC function. ✓
B. Text is always ignored
C. Select entire column for best performance
D. If k is not a multiple of 1/(n - 1), PERCENTILE interpolates to determine the value at the k-th percentile.

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.

7. Which function is related to =PERCENTILE?

A. ATANH
B. TYPE
C. MEDIAN ✓
D. DSTDEVP

Explanation: “MEDIAN” is related to PERCENTILE.

8. Which formula is a valid example of =PERCENTILE?

A. =PERCENTILE(B2:B50, 0.9, 0)
B. =MEDIAN(B2:B50, 0.9)
C. PERCENTILE(B2:B50, 0.9)
D. =PERCENTILE(B2:B50, 0.9) ✓

Explanation: Correct example: =PERCENTILE(B2:B50, 0.9)

9. Is =PERCENTILE volatile?

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

Explanation: PERCENTILE is not volatile.

10. Which is the correct syntax of =PERCENTILE?

A. =PERCENTILE(array,k, 0)
B. =PERCENTILE(array,k) ✓
C. =MEDIAN(array,k)
D. PERCENTILE(array,k)

Explanation: Correct syntax: =PERCENTILE(array,k)

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

A. Output is always a dynamic array
B. If k is non-numeric, PERCENTILE returns the #VALUE! error value. ✓
C. Select entire column for best performance
D. Volatile and recalculates every time

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

12. Which use case fits =PERCENTILE?

A. Conditional Formatting & Validation
B. Securities & Bonds
C. Ranking & Top N ✓
D. Lookup & Retrieval

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

13. What is the fix for #NUM! in =PERCENTILE?

A. Text is always ignored
B. Enter k as a number between 0 and 1 ✓
C. Only works in old versions
D. Requires add-in

Explanation: If k is < 0 or if k > 1, PERCENTILE returns the #NUM! error value. — Fix: Enter k as a number between 0 and 1

14. How many required arguments does =PERCENTILE have?

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

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

15. Since which Excel version is =PERCENTILE available?

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

Explanation: Version: “All versions”.