The table below contains sales totals for the top six term life insurance salespeople
Ask Expert

Be Prepared For The Toughest Questions

Practice Problems

The table below contains sales totals for the top six term life insurance salespeople

The table below contains sales totals for the top six term life insurance salespeople at American Insurance.

Salesperson

Contracts Sold

Harish

24

David

41

Kristina

19

Steven

23

Tim

53

Mona

39

(a) Create a column chart in Excel 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. Choose the correct chart below.


(b) Sort the values in Excel so that the column chart is ordered from most contracts sold to fewest. Insert data labels to display the number of contracts sold for each salesperson above the columns in the column chart created in part a. Choose the correct chart below.


Hint
Statistics"(a) To create a column chart in Excel, follow these steps:Select the data in the table (including the headings).Go to the ""Insert"" tab in the ribbon.Click on the ""Column Chart"" button in the ""Charts"" group.Choose the chart style you prefer.To format the column chart to best display the data, you can add the following elements:Axes labels: Add labels for the horizontal (x) and vert...

Know the process

Students succeed in their courses by connecting and communicating with
an expert until they receive help on their questions

1
img

Submit Question

Post project within your desired price and deadline.

2
img

Tutor Is Assigned

A quality expert with the ability to solve your project will be assigned.

3
img

Receive Help

Check order history for updates. An email as a notification will be sent.

img
Unable to find what you’re looking for?

Consult our trusted tutors.

Developed by Versioning Solutions.