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 type of argument “k” in =PERCENTILE?

Question 2 of 15 2/15

What usually causes #VALUE! in =PERCENTILE?

Question 3 of 15 3/15

How many arguments does =PERCENTILE have in total?

Question 4 of 15 4/15

Which statement about =PERCENTILE is correct?

Question 5 of 15 5/15

Which is the correct syntax of =PERCENTILE?

Question 6 of 15 6/15

In =PERCENTILE, which is argument #2?

Question 7 of 15 7/15

How many optional arguments does =PERCENTILE have?

Question 8 of 15 8/15

How many required arguments does =PERCENTILE have?

Question 9 of 15 9/15

Is argument “array” required in =PERCENTILE?

Question 10 of 15 10/15

Does =PERCENTILE return a dynamic array?

Question 11 of 15 11/15

Which category does =PERCENTILE belong to?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

What is the output type of =PERCENTILE?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

Since which Excel version is =PERCENTILE available?

Click a question to see the answer.

1. What is the type of argument “k” in =PERCENTILE?

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

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

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

A. Only works in old versions
B. Output is always a dynamic array
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 وارد کنید.

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

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

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

4. Which statement about =PERCENTILE is correct?

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

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. 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)

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

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

Explanation: Argument #2 is “k”.

7. How many optional arguments does =PERCENTILE have?

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

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

8. How many required arguments does =PERCENTILE have?

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

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

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

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

Explanation: “array” is required.

10. Does =PERCENTILE return a dynamic array?

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

Explanation: PERCENTILE does not spill.

11. Which category does =PERCENTILE belong to?

A. Logical
B. Database
C. Date & Time
D. Compatibility ✓

Explanation: Category is “Compatibility”.

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

A. Output is always a dynamic array
B. Enter k as a number between 0 and 1 ✓
C. مقدار k غیرعددی است.
D. Select entire column for best performance

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

13. What is the output type of =PERCENTILE?

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

Explanation: Output is “Number”.

14. What is the fix for #VALUE! in =PERCENTILE?

A. مقدار k کوچک‌تر از 0 یا بزرگ‌تر از 1 است.
B. برای k یک مقدار عددی بین 0 تا 1 وارد کنید. ✓
C. Volatile and recalculates every time
D. Only works in old versions

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

15. Since which Excel version is =PERCENTILE available?

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

Explanation: Version: “All versions”.