The Data on the Runs Scored in a Match by Top

question 38

Essay

The data on the runs scored in a match by top 5 players of a cricket team are given below:

a. Create a column chart to display the information in the table above. Format the column chart to best display the data by adding axes labels, a chart title, etc.
b. Sort the values in Excel so that the column chart is ordered from most runs scored to fewest.
c. Insert data labels to display the runs scored by each player above the columns in the column chart obtained in part b.

---

Definitions:

Vertical Analysis

A financial statement analysis method where each line item is listed as a percentage of a base figure within the statement, facilitating comparisons.

Current Liabilities

Current liabilities are financial obligations a company owes and is expected to pay within a year.

Working Capital

The excess of the current assets of a business over its current liabilities.

Current Assets

Assets that are expected to be converted into cash, sold, or used up within one year or within the business's operating cycle.