Cube =CUBEMEMBER(connection, member_expression, [caption])

Quiz =CUBEMEMBER — 15 Questions

15 quiz questions about =CUBEMEMBER — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← CUBEMEMBER ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What usually causes #VALUE! in =CUBEMEMBER?

Question 2 of 15 2/15

Which formula is a valid example of =CUBEMEMBER?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

What is the fix for #VALUE! in =CUBEMEMBER?

Question 5 of 15 5/15

Which statement about =CUBEMEMBER is correct?

Question 6 of 15 6/15

What is the type of argument “member_expression” in =CUBEMEMBER?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

Which is the correct syntax of =CUBEMEMBER?

Question 9 of 15 9/15

How many arguments does =CUBEMEMBER have in total?

Question 10 of 15 10/15

Is argument “member_expression” required in =CUBEMEMBER?

Question 11 of 15 11/15

How many optional arguments does =CUBEMEMBER have?

Question 12 of 15 12/15

Which function is related to =CUBEMEMBER?

Question 13 of 15 13/15

Does =CUBEMEMBER return a dynamic array?

Question 14 of 15 14/15

Is argument “connection” required in =CUBEMEMBER?

Question 15 of 15 15/15

What is the type of argument “connection” in =CUBEMEMBER?

Click a question to see the answer.

1. What usually causes #VALUE! in =CUBEMEMBER?

A. Output is always a dynamic array
B. نام اتصال معتبر نیست یا سرور OLAP در دسترس نیست.
C. Volatile and recalculates every time
D. If at least one element within the tuple is invalid, CUBEMEMBER returns a #VALUE! error value. If member_expression is longer than 255 characters, which is the limit for an argument to a function, CUBEMEMBER returns a #VALUE! error value. ✓

Explanation: If at least one element within the tuple is invalid, CUBEMEMBER returns a #VALUE! error value. If member_expression is longer than 255 characters, which is the limit for an argument to a function, CUBEMEMBER returns a #VALUE! error value. — Fix: اعضای تاپل را بررسی کنید و برای رشته‌های طولانی از مرجع سلول استفاده کنید.

2. Which formula is a valid example of =CUBEMEMBER?

A. CUBEMEMBER("Sales","[Time].[Fiscal].[2004]")
B. =CUBEMEMBER("Sales","[Time].[Fiscal].[2004]", 0)
C. =CUBEMEMBER("Sales","[Time].[Fiscal].[2004]") ✓
D. =CUBEVALUE("Sales","[Time].[Fiscal].[2004]")

Explanation: Correct example: =CUBEMEMBER("Sales","[Time].[Fiscal].[2004]")

3. What is the type of argument “caption” in =CUBEMEMBER?

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

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

4. What is the fix for #VALUE! in =CUBEMEMBER?

A. Requires add-in
B. اعضای تاپل را بررسی کنید و برای رشته‌های طولانی از مرجع سلول استفاده کنید. ✓
C. نحو member_expression نادرست است، عضو در کیوب وجود ندارد، تاپل نامعتبر است، یا مجموعه دارای اعضای با ابعاد متفاوت است.
D. نام اتصال معتبر نیست یا سرور OLAP در دسترس نیست.

5. Which statement about =CUBEMEMBER is correct?

A. Text is always ignored
B. Output is always a dynamic array
C. Requires add-in
D. When the CUBEMEMBER function evaluates, it temporarily displays a "#GETTING_DATA…" message in the cell before all of the data is retrieved. ✓

Explanation: Correct: When the CUBEMEMBER function evaluates, it temporarily displays a "#GETTING_DATA…" message in the cell before all of the data is retrieved.

6. What is the type of argument “member_expression” in =CUBEMEMBER?

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

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

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

A. Volatile and recalculates every time
B. حداقل یک عنصر درون تاپل نامعتبر است یا طول member_expression بیش از ۲۵۵ نویسه است.
C. Text is always ignored
D. Check the connection name in the Connections section ✓

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

8. Which is the correct syntax of =CUBEMEMBER?

A. =CUBEMEMBER(connection, member_expression, [caption], 0)
B. =CUBEMEMBER(connection, member_expression, [caption]) ✓
C. CUBEMEMBER(connection, member_expression, [caption])
D. =CUBEVALUE(connection, member_expression, [caption])

Explanation: Correct syntax: =CUBEMEMBER(connection, member_expression, [caption])

9. How many arguments does =CUBEMEMBER have in total?

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

Explanation: =CUBEMEMBER has 2 required, 1 optional (3 total).

10. Is argument “member_expression” required in =CUBEMEMBER?

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

Explanation: “member_expression” is required.

11. How many optional arguments does =CUBEMEMBER have?

A. 3
B. 2
C. 1 ✓
D. 0

Explanation: =CUBEMEMBER has 2 required, 1 optional (3 total).

12. Which function is related to =CUBEMEMBER?

A. CUBEVALUE ✓
B. SUMIF
C. SERIESSUM
D. DSTDEVP

Explanation: “CUBEVALUE” is related to CUBEMEMBER.

13. Does =CUBEMEMBER return a dynamic array?

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

Explanation: CUBEMEMBER does not spill.

14. Is argument “connection” required in =CUBEMEMBER?

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

Explanation: “connection” is required.

15. What is the type of argument “connection” in =CUBEMEMBER?

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

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