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

Quiz =PERCENTRANK — 15 Questions

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

Question 1 of 15 1/15

Which category does =PERCENTRANK belong to?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

In =PERCENTRANK, which is argument #2?

Question 4 of 15 4/15

Does =PERCENTRANK return a dynamic array?

Question 5 of 15 5/15

How many arguments does =PERCENTRANK have in total?

Question 6 of 15 6/15

In =PERCENTRANK, which is argument #3?

Question 7 of 15 7/15

In =PERCENTRANK, which is argument #1?

Question 8 of 15 8/15

What is the output type of =PERCENTRANK?

Question 9 of 15 9/15

Which formula is a valid example of =PERCENTRANK?

Question 10 of 15 10/15

Which statement about =PERCENTRANK is correct?

Question 11 of 15 11/15

Is =PERCENTRANK volatile?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

What usually causes #NUM! in =PERCENTRANK?

Question 14 of 15 14/15

Which use case fits =PERCENTRANK?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Which category does =PERCENTRANK belong to?

A. Text
B. Compatibility ✓
C. Date & Time
D. Math & Trig

Explanation: Category is “Compatibility”.

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

A. Number
B. Reference
C. Value
D. Range ✓

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

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

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

Explanation: Argument #2 is “x”.

4. Does =PERCENTRANK return a dynamic array?

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

Explanation: PERCENTRANK does not spill.

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

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

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

6. In =PERCENTRANK, which is argument #3?

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

Explanation: Argument #3 is “significance”.

7. In =PERCENTRANK, which is argument #1?

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

Explanation: Argument #1 is “array”.

8. What is the output type of =PERCENTRANK?

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

Explanation: Output is “Number”.

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

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

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

10. Which statement about =PERCENTRANK is correct?

A. Volatile and recalculates every time
B. Only works in old versions
C. 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. ✓
D. Output is always a dynamic array

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.

11. Is =PERCENTRANK volatile?

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

Explanation: PERCENTRANK is not volatile.

12. What is the type of argument “significance” in =PERCENTRANK?

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

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

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

A. Volatile and recalculates every time
B. Text is always ignored
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 یا بیشتر (تعداد ارقام معنادار) وارد کنید.

14. Which use case fits =PERCENTRANK?

A. Reporting ✓
B. Financial Calculations
C. Data Cleaning
D. Advanced Formulas

Explanation: Use case “Reporting” fits PERCENTRANK.

15. What is the type of argument “x” in =PERCENTRANK?

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

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