Compatibility =RANK(number,ref,[order])

Quiz =RANK — 15 Questions

15 quiz questions about =RANK — test syntax, arguments, examples & errors!

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

← RANK ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which category does =RANK belong to?

Question 2 of 15 2/15

What is the type of argument “number” in =RANK?

Question 3 of 15 3/15

What is the type of argument “order” in =RANK?

Question 4 of 15 4/15

Is =RANK volatile?

Question 5 of 15 5/15

Is argument “order” required in =RANK?

Question 6 of 15 6/15

How many arguments does =RANK have in total?

Question 7 of 15 7/15

What is the type of argument “ref” in =RANK?

Question 8 of 15 8/15

Since which Excel version is =RANK available?

Question 9 of 15 9/15

What is the output type of =RANK?

Question 10 of 15 10/15

Does =RANK return a dynamic array?

Question 11 of 15 11/15

Which function is NOT related to =RANK?

Question 12 of 15 12/15

Is argument “ref” required in =RANK?

Question 13 of 15 13/15

Which statement about =RANK is correct?

Question 14 of 15 14/15

Which formula is a valid example of =RANK?

Question 15 of 15 15/15

Is argument “number” required in =RANK?

Click a question to see the answer.

1. Which category does =RANK belong to?

A. Database
B. Logical
C. Lookup & Reference
D. Compatibility ✓

Explanation: Category is “Compatibility”.

2. What is the type of argument “number” in =RANK?

A. Reference
B. Number ✓
C. Mixed
D. Date

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

3. What is the type of argument “order” in =RANK?

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

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

4. Is =RANK volatile?

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

Explanation: RANK is not volatile.

5. Is argument “order” required in =RANK?

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

Explanation: “order” is optional.

6. How many arguments does =RANK have in total?

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

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

7. What is the type of argument “ref” in =RANK?

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

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

8. Since which Excel version is =RANK available?

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

Explanation: Version: “All versions”.

9. What is the output type of =RANK?

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

Explanation: Output is “Number”.

10. Does =RANK return a dynamic array?

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

Explanation: RANK does not spill.

11. Which function is NOT related to =RANK?

A. RANK-AVG
B. CUMIPMT ✓
C. COUNTIF
D. LARGE

Explanation: “CUMIPMT” is not related to RANK.

12. Is argument “ref” required in =RANK?

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

Explanation: “ref” is required.

13. Which statement about =RANK is correct?

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

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.

14. Which formula is a valid example of =RANK?

A. =RANK(A3,A2:A6,1) ✓
B. RANK(A3,A2:A6,1)
C. =RANK(A3,A2:A6,1, 0)
D. =COUNTIF(A3,A2:A6,1)

Explanation: Correct example: =RANK(A3,A2:A6,1)

15. Is argument “number” required in =RANK?

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

Explanation: “number” is required.