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
Which is the correct syntax of =RANK?
Explanation: Correct syntax: =RANK(number,ref,[order])
Question 2 of 10
2/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 3 of 10
3/10
Is argument “order” required in =RANK?
Explanation: “order” is optional.
Question 4 of 10
4/10
Which category does =RANK belong to?
Explanation: Category is “Compatibility”.
Question 5 of 10
5/10
Is argument “number” required in =RANK?
Explanation: “number” is required.
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
What is the type of argument “number” in =RANK?
Explanation: Type of “number” is “Number”.
Question 8 of 10
8/10
Does =RANK return a dynamic array?
Explanation: RANK does not spill.
Question 9 of 10
9/10
Which function is related to =RANK?
Explanation: “COUNTIF” is related to RANK.
Question 10 of 10
10/10
Is argument “ref” required in =RANK?
Explanation: “ref” is required.