An Analytics Manager, Lauren, Is Reviewing the Performance Data of Fifteen

question 46

Multiple Choice

An analytics manager, Lauren, is reviewing the performance data of fifteen branch stores. She wants to create a heat map with symbols as in the figure below. What tool should she use?

• A) Select B4:B18; PivotTable
• B) Select B4:B18; Conditional Formatting; Highlight Cells Rules
• C) Select B4:B18; Conditional Formatting; Icon Sets
• D) Select B1:B18; Conditional Formatting; Icon Sets
• E) Select B4:B18; Conditional Formatting; Data Bars

---

Definitions:

Unit Sales

The number of individual items or units sold within a specific period, often used as a measure of a company's performance.

Traceable Fixed Expense

Fixed costs that can be directly linked to a specific department, product, or segment, helping in the evaluation of its profitability.

Price Increase

Adjusting the selling price of goods or services upwards, often as a response to inflating costs or improving margin.

Useful Life

The period over which an asset is expected to be usable for its intended purpose, affecting depreciation calculations.