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
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
Is argument “number” required in =RANK?
Explanation: “number” is required.
Question 2 of 10
2/10
What is the output type of =RANK?
Explanation: Output is “Number”.
Question 3 of 10
3/10
What is the type of argument “ref” in =RANK?
Explanation: Type of “ref” is “Range”.
Question 4 of 10
4/10
How many arguments does =RANK have in total?
Explanation: =RANK has 2 required, 1 optional (3 total).
Question 5 of 10
5/10
Is =RANK volatile?
Explanation: RANK is not volatile.
Question 6 of 10
6/10
Which formula is a valid example of =RANK?
Explanation: Correct example: =RANK(A3,A2:A6,1)
Question 7 of 10
7/10
Which category does =RANK belong to?
Explanation: Category is “Compatibility”.
Question 8 of 10
8/10
Which use case fits =RANK?
Explanation: Use case “Ranking & Top N” fits RANK.
Question 9 of 10
9/10
Which statement about =RANK is correct?
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.
Question 10 of 10
10/10
In =RANK, which is argument #1?
Explanation: Argument #1 is “number”.