Compatibility =PERCENTRANK(array,x,[significance])

Quiz =PERCENTRANK — 10 Questions

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

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

← PERCENTRANK ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which use case fits =PERCENTRANK?

Question 2 of 10 2/10

Which formula is a valid example of =PERCENTRANK?

Question 3 of 10 3/10

Is argument “x” required in =PERCENTRANK?

Question 4 of 10 4/10

In =PERCENTRANK, which is argument #2?

Question 5 of 10 5/10

What usually causes #NUM! in =PERCENTRANK?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Which function is NOT related to =PERCENTRANK?

Question 8 of 10 8/10

How many required arguments does =PERCENTRANK have?

Question 9 of 10 9/10

Does =PERCENTRANK return a dynamic array?

Question 10 of 10 10/10

Which statement about =PERCENTRANK is correct?

Click a question to see the answer.

1. Which use case fits =PERCENTRANK?

A. Conditional Aggregation
B. Conditional Logic
C. Workdays & Due Dates
D. Reporting ✓

Explanation: Use case “Reporting” fits PERCENTRANK.

2. Which formula is a valid example of =PERCENTRANK?

A. =PERCENTRANK(A2:A11,2, 0)
B. =PERCENTRANK(A2:A11,2) ✓
C. PERCENTRANK(A2:A11,2)
D. =FORECAST(A2:A11,2)

Explanation: Correct example: =PERCENTRANK(A2:A11,2)

3. Is argument “x” required in =PERCENTRANK?

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

Explanation: “x” is required.

4. In =PERCENTRANK, which is argument #2?

A. lookup_value
B. value
C. array
D. x ✓

Explanation: Argument #2 is “x”.

5. What usually causes #NUM! in =PERCENTRANK?

A. Only works in old versions
B. Volatile and recalculates every time
C. Select entire column for best performance
D. If the array is empty, PERCENTRANK returns the #NUM! error value. If significance < 1, PERCENTRANK returns the #NUM! error value. ✓

Explanation: If the array is empty, PERCENTRANK returns the #NUM! error value. If significance < 1, PERCENTRANK returns the #NUM! error value. — Fix: مطمئن شوید آرایه پر است و برای significance عدد صحیح 1 یا بیشتر (تعداد ارقام معنادار) وارد کنید.

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

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

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

7. Which function is NOT related to =PERCENTRANK?

A. MODE
B. FLOOR.MATH ✓
C. PERCENTILE
D. FORECAST

Explanation: “FLOOR.MATH” is not related to PERCENTRANK.

8. How many required arguments does =PERCENTRANK have?

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

Explanation: =PERCENTRANK has 2 required, 1 optional (3 total).

9. Does =PERCENTRANK return a dynamic array?

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

Explanation: PERCENTRANK does not spill.

10. Which statement about =PERCENTRANK is correct?

A. This function has been replaced along with other functions that may provide improved accuracy and whose names better reflect their purpose. This function remains available for backward compatibility but may not be available in future versions of Excel. Consider now using the newer functions. ✓
B. Requires add-in
C. Volatile and recalculates every time
D. If X does not specifically match one of the values in the array (e.g., a list of specific student test scores) PERCENTRANK interpolates to return a percentage rank for X.

Explanation: Correct: This function has been replaced along with other functions that may provide improved accuracy and whose names better reflect their purpose. This function remains available for backward compatibility but may not be available in future versions of Excel. Consider now using the newer functions.