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:

Profitability

A measure of the efficiency and financial performance of a business, indicating its ability to generate income relative to revenue, assets, or equity.

Significant Influence

The power to participate in the financial and operating policy decisions of an investee but not control those policies.

Voting Shares

Shares that give the shareholder the right to vote on company matters at shareholder meetings.

ASPE

Accounting Standards for Private Enterprises, a set of accounting principles for private companies in Canada.