Cube =CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])

Quiz =CUBEKPIMEMBER — 15 Questions

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

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

← CUBEKPIMEMBER ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which function is related to =CUBEKPIMEMBER?

Question 2 of 15 2/15

Is =CUBEKPIMEMBER volatile?

Question 3 of 15 3/15

Which category does =CUBEKPIMEMBER belong to?

Question 4 of 15 4/15

Does =CUBEKPIMEMBER return a dynamic array?

Question 5 of 15 5/15

What is the type of argument “kpi_name” in =CUBEKPIMEMBER?

Question 6 of 15 6/15

How many required arguments does =CUBEKPIMEMBER have?

Question 7 of 15 7/15

What is the output type of =CUBEKPIMEMBER?

Question 8 of 15 8/15

What usually causes #N/A in =CUBEKPIMEMBER?

Question 9 of 15 9/15

In =CUBEKPIMEMBER, which is argument #3?

Question 10 of 15 10/15

In =CUBEKPIMEMBER, which is argument #2?

Question 11 of 15 11/15

Which use case fits =CUBEKPIMEMBER?

Question 12 of 15 12/15

How many optional arguments does =CUBEKPIMEMBER have?

Question 13 of 15 13/15

How many arguments does =CUBEKPIMEMBER have in total?

Question 14 of 15 14/15

Which function is NOT related to =CUBEKPIMEMBER?

Question 15 of 15 15/15

Since which Excel version is =CUBEKPIMEMBER available?

Click a question to see the answer.

1. Which function is related to =CUBEKPIMEMBER?

A. HSTACK
B. HLOOKUP
C. F.INV
D. CUBEVALUE ✓

Explanation: “CUBEVALUE” is related to CUBEKPIMEMBER.

2. Is =CUBEKPIMEMBER volatile?

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

Explanation: CUBEKPIMEMBER is not volatile.

3. Which category does =CUBEKPIMEMBER belong to?

A. Logical
B. Cube ✓
C. Information
D. Text

Explanation: Category is “Cube”.

4. Does =CUBEKPIMEMBER return a dynamic array?

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

Explanation: CUBEKPIMEMBER does not spill.

5. What is the type of argument “kpi_name” in =CUBEKPIMEMBER?

A. Value
B. Array
C. Number
D. Text ✓

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

6. How many required arguments does =CUBEKPIMEMBER have?

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

Explanation: =CUBEKPIMEMBER has 3 required, 2 optional (5 total).

7. What is the output type of =CUBEKPIMEMBER?

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

Explanation: Output is “Mixed”.

8. What usually causes #N/A in =CUBEKPIMEMBER?

A. Output is always a dynamic array
B. CUBEKPIMEMBER returns a #N/A error value when kpi_name or kpi_property is invalid. CUBEKPIMEMBER 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.) ✓
C. Text is always ignored
D. Requires add-in

Explanation: CUBEKPIMEMBER returns a #N/A error value when kpi_name or kpi_property is invalid. CUBEKPIMEMBER 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: نام KPI و ویژگی آن را بررسی کنید و در صورت اشتراک اتصال، از ارجاع به اعضای محاسبه‌شده مبتنی بر جلسه خودداری کنید.

9. In =CUBEKPIMEMBER, which is argument #3?

A. range
B. if
C. kpi_property ✓
D. lookup_value

Explanation: Argument #3 is “kpi_property”.

10. In =CUBEKPIMEMBER, which is argument #2?

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

Explanation: Argument #2 is “kpi_name”.

11. Which use case fits =CUBEKPIMEMBER?

A. Financial Calculations
B. External Data, Web & Cube ✓
C. Data Cleaning
D. Investment Appraisal

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

12. How many optional arguments does =CUBEKPIMEMBER have?

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

Explanation: =CUBEKPIMEMBER has 3 required, 2 optional (5 total).

13. How many arguments does =CUBEKPIMEMBER have in total?

A. 5 ✓
B. 7
C. 6
D. 4

Explanation: =CUBEKPIMEMBER has 3 required, 2 optional (5 total).

14. Which function is NOT related to =CUBEKPIMEMBER?

A. CUBEMEMBER
B. RIGHT ✓
C. CUBEVALUE
D. CUBEKPIMEMBER_X

Explanation: “RIGHT” is not related to CUBEKPIMEMBER.

15. Since which Excel version is =CUBEKPIMEMBER available?

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

Explanation: Version: “Excel 2007”.