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:

Cultural Expression

The representation of a community's beliefs, customs, and way of life through various forms such as art, music, or literature.

Commercial Expression

Any form of communication or artistic work primarily intended for or driven by the motive of profit and market success.

Product Placement

A marketing strategy that involves placing a brand, product, or service within the content of a media production, such as movies or television shows, to increase visibility.

Identity Incentives

Refers to motivations or rewards that align with and reinforce an individual's sense of self or group identity.