Analyzing and Visualizing Data with Microsoft Excel — Question 54

You are building a KPI.
You need to configure the KPI to display a red icon when the sales from a month is less than nine percent of the sales from the last 12 months.
What should you use to define the target value?

Answer options

• A. a measure
• B. a calculated column
• C. a calculated field
• D. an absolute value

Correct answer: A

Explanation

The correct answer is A, a measure, because it allows for dynamic calculations based on the sales data. The other options, such as a calculated column or calculated field, do not provide the necessary functionality to define targets based on aggregate data like sales over the last 12 months.