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

In =CUBERANKEDMEMBER, which is argument #1?

Question 2 of 10 2/10

What is the output type of =CUBERANKEDMEMBER?

Question 3 of 10 3/10

Which use case fits =CUBERANKEDMEMBER?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

In =CUBERANKEDMEMBER, which is argument #2?

Question 6 of 10 6/10

Which is the correct syntax of =CUBERANKEDMEMBER?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

Is argument “caption” required in =CUBERANKEDMEMBER?

Question 9 of 10 9/10

Is =CUBERANKEDMEMBER volatile?

Question 10 of 10 10/10

Does =CUBERANKEDMEMBER return a dynamic array?

Click a question to see the answer.

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

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

Explanation: Argument #1 is “connection”.

2. What is the output type of =CUBERANKEDMEMBER?

A. Logical
B. Mixed ✓
C. Date
D. Text

Explanation: Output is “Mixed”.

3. Which use case fits =CUBERANKEDMEMBER?

A. External Data, Web & Cube ✓
B. Depreciation
C. Loans & Installments
D. Lookup & Retrieval

Explanation: Use case “External Data, Web & Cube” fits CUBERANKEDMEMBER.

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

A. Text is always ignored
B. Check the connection name in the Connections section ✓
C. Output is always a dynamic array
D. Volatile and recalculates every time

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

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

A. caption
B. criteria
C. lookup_value
D. set_expression ✓

Explanation: Argument #2 is “set_expression”.

6. Which is the correct syntax of =CUBERANKEDMEMBER?

A. =CUBESET(connection, set_expression, rank, [caption])
B. =CUBERANKEDMEMBER(connection, set_expression, rank, [caption]) ✓
C. CUBERANKEDMEMBER(connection, set_expression, rank, [caption])
D. =CUBERANKEDMEMBER(connection, set_expression, rank, [caption], 0)

Explanation: Correct syntax: =CUBERANKEDMEMBER(connection, set_expression, rank, [caption])

7. What is the type of argument “rank” in =CUBERANKEDMEMBER?

A. Mixed
B. Value
C. Logical
D. Number ✓

Explanation: Type of “rank” is “Number”.

8. Is argument “caption” required in =CUBERANKEDMEMBER?

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

Explanation: “caption” is optional.

9. Is =CUBERANKEDMEMBER volatile?

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

Explanation: CUBERANKEDMEMBER is not volatile.

10. Does =CUBERANKEDMEMBER return a dynamic array?

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

Explanation: CUBERANKEDMEMBER does not spill.