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.
Students succeed in their courses by connecting and communicating with an expert until they receive help on their questions
Consult our trusted tutors.