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

How many optional arguments does =RANK have?

Question 2 of 15 2/15

Is argument “ref” required in =RANK?

Question 3 of 15 3/15

Which category does =RANK belong to?

Question 4 of 15 4/15

Does =RANK return a dynamic array?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

What is the output type of =RANK?

Question 7 of 15 7/15

Which statement about =RANK is correct?

Question 8 of 15 8/15

Is =RANK volatile?

Question 9 of 15 9/15

In =RANK, which is argument #3?

Question 10 of 15 10/15

How many required arguments does =RANK have?

Question 11 of 15 11/15

Since which Excel version is =RANK available?

Question 12 of 15 12/15

Which use case fits =RANK?

Question 13 of 15 13/15

Which is the correct syntax of =RANK?

Question 14 of 15 14/15

In =RANK, which is argument #2?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. How many optional arguments does =RANK have?

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

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

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

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

Explanation: “ref” is required.

3. Which category does =RANK belong to?

A. Date & Time
B. Cube
C. Logical
D. Compatibility ✓

Explanation: Category is “Compatibility”.

4. Does =RANK return a dynamic array?

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

Explanation: RANK does not spill.

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

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

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

6. What is the output type of =RANK?

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

Explanation: Output is “Number”.

7. Which statement about =RANK 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. ✓
B. Text is always ignored
C. Select entire column for best performance
D. Requires add-in

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.

8. Is =RANK volatile?

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

Explanation: RANK is not volatile.

9. In =RANK, which is argument #3?

A. value
B. order ✓
C. criteria
D. ref

Explanation: Argument #3 is “order”.

10. How many required arguments does =RANK have?

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

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

11. Since which Excel version is =RANK available?

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

Explanation: Version: “All versions”.

12. Which use case fits =RANK?

A. Reporting
B. Ranking & Top N ✓
C. Comparation
D. Conditional Aggregation

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

13. Which is the correct syntax of =RANK?

A. RANK(number,ref,[order])
B. =RANK(number,ref,[order]) ✓
C. =COUNTIF(number,ref,[order])
D. =RANK(number,ref,[order], 0)

Explanation: Correct syntax: =RANK(number,ref,[order])

14. In =RANK, which is argument #2?

A. range
B. ref ✓
C. number
D. criteria

Explanation: Argument #2 is “ref”.

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

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

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