Cube
=CUBERANKEDMEMBER(connection, set_expression, rank, [caption])
Quiz =CUBERANKEDMEMBER — 10 Questions
10 quiz questions about =CUBERANKEDMEMBER — 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
What is the type of argument “rank” in =CUBERANKEDMEMBER?
Explanation: Type of “rank” is “Number”.
Question 2 of 10
2/10
Which function is NOT related to =CUBERANKEDMEMBER?
Explanation: “ACCRINT” is not related to CUBERANKEDMEMBER.
Question 3 of 10
3/10
Which formula is a valid example of =CUBERANKEDMEMBER?
Explanation: Correct example: =CUBERANKEDMEMBER("Sales",$D$4,1,"Top Month")
Question 4 of 10
4/10
What usually causes #N/A in =CUBERANKEDMEMBER?
Explanation: CUBERANKEDMEMBER returns a #N/A error value when the syntax of set_expression is incorrect or when the set contains at least one member with a different dimension than the other members. — Fix: نحو عبارت مجموعه و سازگاری ابعاد اعضا را بررسی کنید.
Question 5 of 10
5/10
In =CUBERANKEDMEMBER, which is argument #2?
Explanation: Argument #2 is “set_expression”.
Question 6 of 10
6/10
Is argument “rank” required in =CUBERANKEDMEMBER?
Explanation: “rank” is required.
Question 7 of 10
7/10
Which statement about =CUBERANKEDMEMBER is correct?
Explanation: Correct: To return the bottom n values, use the sort_order and sort_by arguments of the CUBESET function to reverse the order of the set so that the top values in the sorted set are the bottom values. For example, CUBERANKEDMEMBER ("Sales", $D$4,1) returns the last member, CUBERANKEDMEMBER ("Sales", $D$4, 2) returns the next to last member, and so on.
Question 8 of 10
8/10
Is argument “connection” required in =CUBERANKEDMEMBER?
Explanation: “connection” is required.
Question 9 of 10
9/10
Does =CUBERANKEDMEMBER return a dynamic array?
Explanation: CUBERANKEDMEMBER does not spill.
Question 10 of 10
10/10
What is the fix for #N/A in =CUBERANKEDMEMBER?
Explanation: CUBERANKEDMEMBER returns a #N/A error value when the syntax of set_expression is incorrect or when the set contains at least one member with a different dimension than the other members. — Fix: نحو عبارت مجموعه و سازگاری ابعاد اعضا را بررسی کنید.