Matthew, the Head of the Sales Department, Has Noticed a Significant

question 19

Multiple Choice

Matthew, the head of the sales department, has noticed a significant decline in performance in one of his sales teams over the years. He wants to compare the team's performance data over the last five years to study the exact decline percentage. Which of the following Microsoft Excel diagrams should Matthew use for this purpose?

• A) pie charts
• B) column charts
• C) doughnut charts
• D) Venn diagrams

---

Definitions:

Cost of Equity

The return a company requires to decide if an investment meets capital return requirements and is often used to assess the cost of funding.

Risk-Free Rate

The theoretical return of an investment with zero risk, often represented by the yield on government securities like U.S. Treasury bonds.

Beta

A metric for assessing the uncertainty, or inherent danger, of an individual security or collective investment compared to the market at large.

Common Stock

Represents equity ownership in a corporation, giving holders voting rights and a share in the company's profits via dividends.