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

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