Analyzing and Visualizing Data with Microsoft Excel — Question 34

You have a measure named SalesGrowth that calculates the percent of sales growth. The measure uses the following formula.
([Total Sales Current Year] "" [Total Sales Last year]) / [Total Sales Last Year]
Total Sales Current Year is a measure that calculates the sales from the current calendar year. Total Sales Last Year is a measure that calculates the sales from the previous calendar year.
You need to create a KPI that displays a red icon when the sales growth is less than last year.
What should you use to define the target value?

Answer options

• A. the Total Sales Current Year measure
• B. an absolute value of 0
• C. the Total Sales Last Year measure
• D. an absolute value of 100

Correct answer: C

Explanation

The correct answer is C because the KPI needs to compare the current year's sales growth against the previous year's sales, which is represented by the Total Sales Last Year measure. Option A is incorrect as it refers to current sales, not last year's growth. Option B is not appropriate since a growth metric should be compared against last year's sales, and option D is irrelevant as it does not reflect the actual sales figures needed for comparison.