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

← CUBERANKEDMEMBER ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which statement about =CUBERANKEDMEMBER is correct?

Question 2 of 10 2/10

Is argument “rank” required in =CUBERANKEDMEMBER?

Question 3 of 10 3/10

In =CUBERANKEDMEMBER, which is argument #1?

Question 4 of 10 4/10

What usually causes #N/A in =CUBERANKEDMEMBER?

Question 5 of 10 5/10

In =CUBERANKEDMEMBER, which is argument #3?

Question 6 of 10 6/10

What is the type of argument “caption” in =CUBERANKEDMEMBER?

Question 7 of 10 7/10

What is the fix for #NAME? in =CUBERANKEDMEMBER?

Question 8 of 10 8/10

Does =CUBERANKEDMEMBER return a dynamic array?

Question 9 of 10 9/10

How many required arguments does =CUBERANKEDMEMBER have?

Question 10 of 10 10/10

Since which Excel version is =CUBERANKEDMEMBER available?

Click a question to see the answer.

1. Which statement about =CUBERANKEDMEMBER is correct?

A. Only works in old versions
B. 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. ✓
C. Volatile and recalculates every time
D. Select entire column for best performance

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.

2. Is argument “rank” required in =CUBERANKEDMEMBER?

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

Explanation: “rank” is required.

3. In =CUBERANKEDMEMBER, which is argument #1?

A. set_expression
B. caption
C. range
D. connection ✓

Explanation: Argument #1 is “connection”.

4. What usually causes #N/A in =CUBERANKEDMEMBER?

A. Only works in old versions
B. نام اتصال معتبر نیست یا سرور OLAP در دسترس نیست.
C. Requires add-in
D. 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. ✓

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: نحو عبارت مجموعه و سازگاری ابعاد اعضا را بررسی کنید.

5. In =CUBERANKEDMEMBER, which is argument #3?

A. lookup_value
B. caption
C. value
D. rank ✓

Explanation: Argument #3 is “rank”.

6. What is the type of argument “caption” in =CUBERANKEDMEMBER?

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

Explanation: Type of “caption” is “Text”.

7. What is the fix for #NAME? in =CUBERANKEDMEMBER?

A. Select entire column for best performance
B. Check the connection name in the Connections section ✓
C. Volatile and recalculates every time
D. Output is always a dynamic array

Explanation: If the connection name is not a valid workbook connection stored in the workbook, CUBERANKEDMEMBER returns a #NAME? error value. If the Online Analytical Processing (OLAP) server is not running, not available, or returns an error message, CUBERANKEDMEMBER returns a #NAME? error value. — Fix: Check the connection name in the Connections section

8. Does =CUBERANKEDMEMBER return a dynamic array?

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

Explanation: CUBERANKEDMEMBER does not spill.

9. How many required arguments does =CUBERANKEDMEMBER have?

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

Explanation: =CUBERANKEDMEMBER has 3 required, 1 optional (4 total).

10. Since which Excel version is =CUBERANKEDMEMBER available?

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

Explanation: Version: “Excel 2007”.