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

How many required arguments does =PERCENTILE have?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

In =PERCENTILE, which is argument #2?

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

Is argument “k” required in =PERCENTILE?

Question 7 of 10 7/10

What usually causes #NUM! in =PERCENTILE?

Question 8 of 10 8/10

Which function is related to =PERCENTILE?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

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

Click a question to see the answer.

1. How many required arguments does =PERCENTILE have?

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

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

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

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

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

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

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

Explanation: Argument #2 is “k”.

4. 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. If k is not a multiple of 1/(n - 1), PERCENTILE interpolates to determine the value at the k-th percentile.
C. Select entire column for best performance
D. Volatile and recalculates every time

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. Is argument “k” required in =PERCENTILE?

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

Explanation: “k” is required.

7. What usually causes #NUM! in =PERCENTILE?

A. Select entire column for best performance
B. Output is always a dynamic array
C. If k is < 0 or if k > 1, PERCENTILE returns the #NUM! error value. ✓
D. Only works in old versions

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

8. Which function is related to =PERCENTILE?

A. CUBERANKEDMEMBER
B. DSUM
C. MEDIAN ✓
D. STDEVP

Explanation: “MEDIAN” is related to PERCENTILE.

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

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

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

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

A. Value
B. Array ✓
C. Logical
D. Text

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