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:

Exporting

The act of sending goods or services to another country for sale.

Licensing

A business arrangement in which one company gives another company permission to manufacture its product for a specified payment.

Least Risky

Describes an option or decision that poses the smallest potential for loss, harm, or adverse outcomes.

Joint Venture

A business arrangement where two or more parties agree to pool their resources for the purpose of accomplishing a specific task or project.