Cube
=CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])
Quiz =CUBEKPIMEMBER — 10 Questions
10 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
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
In =CUBEKPIMEMBER, which is argument #3?
Explanation: Argument #3 is “kpi_property”.
Question 2 of 10
2/10
Which is the correct syntax of =CUBEKPIMEMBER?
Explanation: Correct syntax: =CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])
Question 3 of 10
3/10
What is the type of argument “if” in =CUBEKPIMEMBER?
Explanation: Type of “if” is “Number”.
Question 4 of 10
4/10
Which category does =CUBEKPIMEMBER belong to?
Explanation: Category is “Cube”.
Question 5 of 10
5/10
Is argument “caption” required in =CUBEKPIMEMBER?
Explanation: “caption” is optional.
Question 6 of 10
6/10
In =CUBEKPIMEMBER, which is argument #2?
Explanation: Argument #2 is “kpi_name”.
Question 7 of 10
7/10
How many arguments does =CUBEKPIMEMBER have in total?
Explanation: =CUBEKPIMEMBER has 3 required, 2 optional (5 total).
Question 8 of 10
8/10
Since which Excel version is =CUBEKPIMEMBER available?
Explanation: Version: “Excel 2007”.
Question 9 of 10
9/10
Is argument “if” required in =CUBEKPIMEMBER?
Explanation: “if” is optional.
Question 10 of 10
10/10
What is the fix for #NAME? in =CUBEKPIMEMBER?
Explanation: If the connection name is not a valid workbook connection that is stored in the workbook, CUBEKPIMEMBER returns a #NAME? error value. If the Online Analytical Processing (OLAP) server is not running, not available, or returns an error message, CUBEKPIMEMBER returns a #NAME? error value. — Fix: Check the connection name in the Connections section