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 statement about =PERCENTRANK is correct?

Question 2 of 10 2/10

Which formula is a valid example of =PERCENTRANK?

Question 3 of 10 3/10

How many arguments does =PERCENTRANK have in total?

Question 4 of 10 4/10

What usually causes #NUM! in =PERCENTRANK?

Question 5 of 10 5/10

Does =PERCENTRANK return a dynamic array?

Question 6 of 10 6/10

Since which Excel version is =PERCENTRANK available?

Question 7 of 10 7/10

Is argument “x” required in =PERCENTRANK?

Question 8 of 10 8/10

How many optional arguments does =PERCENTRANK have?

Question 9 of 10 9/10

Is argument “array” required in =PERCENTRANK?

Question 10 of 10 10/10

Which category does =PERCENTRANK belong to?

Click a question to see the answer.

1. 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. Output is always a dynamic array
C. Volatile and recalculates every time
D. Requires add-in

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.

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

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

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

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

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

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

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

A. Volatile and recalculates every time
B. If the array is empty, PERCENTRANK returns the #NUM! error value. If significance < 1, PERCENTRANK returns the #NUM! error value. ✓
C. Text is always ignored
D. Output is always a dynamic array

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

5. Does =PERCENTRANK return a dynamic array?

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

Explanation: PERCENTRANK does not spill.

6. Since which Excel version is =PERCENTRANK available?

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

Explanation: Version: “Excel 2007 (Compatibility)”.

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

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

Explanation: “x” is required.

8. How many optional arguments does =PERCENTRANK have?

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

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

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

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

Explanation: “array” is required.

10. Which category does =PERCENTRANK belong to?

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

Explanation: Category is “Compatibility”.