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

Which formula is a valid example of =PERCENTILE?

Question 2 of 10 2/10

In =PERCENTILE, which is argument #1?

Question 3 of 10 3/10

Which statement about =PERCENTILE is correct?

Question 4 of 10 4/10

Since which Excel version is =PERCENTILE available?

Question 5 of 10 5/10

Which function is NOT related to =PERCENTILE?

Question 6 of 10 6/10

Which is the correct syntax of =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

Which use case fits =PERCENTILE?

Question 10 of 10 10/10

How many optional arguments does =PERCENTILE have?

Click a question to see the answer.

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

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

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

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

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

Explanation: Argument #1 is “array”.

3. 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. Requires add-in
C. Output is always a dynamic array
D. Select entire column for best performance

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.

4. Since which Excel version is =PERCENTILE available?

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

Explanation: Version: “All versions”.

5. Which function is NOT related to =PERCENTILE?

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

Explanation: “DATEVALUE” is not related to PERCENTILE.

6. Which is the correct syntax of =PERCENTILE?

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

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

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

A. مقدار k غیرعددی است.
B. If k is < 0 or if k > 1, PERCENTILE returns the #NUM! error value. ✓
C. Requires add-in
D. Output is always a dynamic array

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. ISBLANK
B. MEDIAN ✓
C. TTEST
D. CONCATENATE

Explanation: “MEDIAN” is related to PERCENTILE.

9. Which use case fits =PERCENTILE?

A. Descriptive Statistics
B. External Data, Web & Cube
C. Conditional Formatting & Validation
D. Ranking & Top N ✓

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

10. How many optional arguments does =PERCENTILE have?

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

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