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

Quiz =CUBEMEMBER — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

Is =CUBEMEMBER volatile?

Question 2 of 10 2/10

Since which Excel version is =CUBEMEMBER available?

Question 3 of 10 3/10

Which is the correct syntax of =CUBEMEMBER?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

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

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Which function is related to =CUBEMEMBER?

Question 8 of 10 8/10

What is the fix for #N/A in =CUBEMEMBER?

Question 9 of 10 9/10

What usually causes #VALUE! in =CUBEMEMBER?

Question 10 of 10 10/10

Which use case fits =CUBEMEMBER?

Click a question to see the answer.

1. Is =CUBEMEMBER volatile?

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

Explanation: CUBEMEMBER is not volatile.

2. Since which Excel version is =CUBEMEMBER available?

A. All versions
B. Excel 2019
C. Excel 365
D. Excel 2007 ✓

Explanation: Version: “Excel 2007”.

3. Which is the correct syntax of =CUBEMEMBER?

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

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

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

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

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

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

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

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

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

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

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: اعضای تاپل را بررسی کنید و برای رشته‌های طولانی از مرجع سلول استفاده کنید.

7. Which function is related to =CUBEMEMBER?

A. VAR.P
B. NORMSDIST
C. ERFC
D. CUBEVALUE ✓

Explanation: “CUBEVALUE” is related to CUBEMEMBER.

8. What is the fix for #N/A in =CUBEMEMBER?

A. Volatile and recalculates every time
B. نحو MDX، وجود عضو در کیوب و سازگاری ابعاد اعضای مجموعه را بررسی کنید. ✓
C. نام اتصال معتبر نیست یا سرور OLAP در دسترس نیست.
D. Only works in old versions

Explanation: CUBEMEMBER returns a #N/A error value when: The member_expression syntax is incorrect. CUBEMEMBER may return a #N/A error value if you reference a session-based object, such as a calculated member or named set, in a PivotTable when sharing a connection, and that PivotTable is deleted or you convert the PivotTable to formulas. (On the Options tab, in the Tools group, click OLAP Tools, and then click Convert to Formulas.) — Fix: نحو MDX، وجود عضو در کیوب و سازگاری ابعاد اعضای مجموعه را بررسی کنید.

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

A. Output is always a dynamic array
B. Text is always ignored
C. نام اتصال معتبر نیست یا سرور OLAP در دسترس نیست.
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. ✓

10. Which use case fits =CUBEMEMBER?

A. Forecasting & Trends
B. Worksheet Info & Navigation
C. Ranking & Top N
D. External Data, Web & Cube ✓

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