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 53 Tim 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. (i) American Insurance Top Six Term-Life Insurance Salespeople Contracts Sold 60 50 40 30 20 10 0 53 41 24 23 39 19 tuti Harish David Kristina Steven Tim Mona Salesperson (ii) (iii) Contracts Sold 60 50 40 American Insurance Top Six Term-Life Insurance Salespeople 30 19 20 20 10 Contracts Sold 0 60 50 40 23 24 24 Harish David Kristina 39 41 53 Steven Tim Mona Salesperson American Insurance Top Six Term-Life Insurance Salespeople 30 24 20 20 20 10 41 19 23 53 39 0 Harish David Kristina Steven Tim Mona Salesperson (iv) 60 American Insurance Top Six Term-Life Insurance Salespeople 53 39 23 19 24 50 41 40 0 Harish David Kristina Steven Tim Mona Salesperson 30 20 10 - Select your answer (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. (i) American Insurance Top Six Term-Life 60 53 50 40 30 20 10 Insurance Salespeople 41 39 24 23 19 0 Tim David Mona Harish Steven Kristina Salesperson (ii) American Insurance Top Six Term-Life Insurance Salespeople 60 50 50 Contracts Sold (iii) 40 30 20 20 10 0 60 60 Contracts Sold 50 41 24 23 19 15 Tim David Mona Harish Steven Kristina Salesperson American Insurance Top Six Term-Life Insurance Salespeople 40 40 39 30 20 20 10 10 24 51 41 23 19 0 Tim David Mona Harish Steven Kristina Salesperson (iv) 650 60 American Insurance Top Six Term-Life Insurance Salespeople 50 53 Contracts Sold 40 30 20 10 41 39 H 24 24 23 19 0 Harish David Kristina Steven Tim Mona Salesperson Select your