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

Quiz =RANK — 10 Questions

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

Question 1 of 10 1/10

Which category does =RANK belong to?

Question 2 of 10 2/10

In =RANK, which is argument #1?

Question 3 of 10 3/10

Which formula is a valid example of =RANK?

Question 4 of 10 4/10

Which use case fits =RANK?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Is =RANK volatile?

Question 7 of 10 7/10

In =RANK, which is argument #2?

Question 8 of 10 8/10

Is argument “order” required in =RANK?

Question 9 of 10 9/10

Is argument “ref” required in =RANK?

Question 10 of 10 10/10

Which statement about =RANK is correct?

Click a question to see the answer.

1. Which category does =RANK belong to?

A. Engineering
B. Financial
C. Statistical
D. Compatibility ✓

Explanation: Category is “Compatibility”.

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

A. order
B. number ✓
C. lookup_value
D. value

Explanation: Argument #1 is “number”.

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

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

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

4. Which use case fits =RANK?

A. Ranking & Top N ✓
B. Conditional Logic
C. Data Cleaning
D. Dynamic Ranges & Dashboards

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

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

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

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

6. Is =RANK volatile?

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

Explanation: RANK is not volatile.

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

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

Explanation: Argument #2 is “ref”.

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

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

Explanation: “order” is optional.

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

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

Explanation: “ref” is required.

10. Which statement about =RANK is correct?

A. Select entire column for best performance
B. Text is always ignored
C. Output is always a dynamic array
D. 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. ✓

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.