Analyzing and Visualizing Data with Microsoft Excel — Question 94

You have a measure that is used by a KPI.
You need to display the output of the measure in a cell in your workbook.
Which Excel function should you use?

Answer options

• A. CUBEVALUE
• B. LOOKUP
• C. VLOOKUP
• D. CUBESET

Correct answer: A

Explanation

The correct answer is A, CUBEVALUE, because it is specifically designed to retrieve the value of a measure from a cube. The other functions, such as LOOKUP and VLOOKUP, are primarily used for searching through tables or ranges, and CUBESET is intended for defining a set of data rather than fetching a single measure's value.