The table below contains sales totals for the top six term life insurance salespeople at American Insurance Salesperson Contracts Sold Harish 24 David Kristina 41 19 23 Steven Tim 53 39 Mona (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 Inbels, chart title, etc. Choose the correct chart below. (1) American Insurance Top Six Term-Life Insurance Salespeople GO 53 50 40 Contracte Sold 30 ilui. 20 . 10 Dave Eriti Tim MO Salesperson (11) American Insurance Top Six Term-Life Insurance Salespeople 60 53 50 41 40 39 Contracts Sold 30 23 24 19 il 20 10 0 Harish David Steven Tim Mona Kristina Salesperson (III) American Insurance Top Six Term-Life Insurance Salespeople 60 53 50 41 40 39 Contracts Sold 30 24 23 19 20 10 0 Harish David Kristina Steven Tim Mond SSD (1) American Insurance Top Six Term-Life Insurance Salespeople 60 41 40 39 Contracts Sold 24 23 20 13 10 Harish David Tim Mon Kristina Steven Salesperson - 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 for each salesperson above the columns in the column chart created in part a. Choose the correct chart below. American Insurance Top Six Term-Life Insurance Salespeople (1) 60 53 50 41 39 acts Sold (1) American Insurance Top Six Term-Life Insurance Salespeople 60 53 50 41 40 39 Contracts Sold 30 24 23 20 19 10 0 Tim David Steven Kristina Mona Harish Salesperson (1) American Insurance Top Six Term-Life Insurance Salespeople 60 50 50 41 40 Contracts Sold 30 24 23 19 20 15 10 0 Tim David Mona Harish Steven Kristina American Insurance Top Six Term-Lile Insurance Salespeople S 51 41 Contracts Sold 24 23 19 20 10 TI David Steven Kristina Mona Haris Salesperson (lv) American Insurance Top Six Term-Life Insurance Salespeople 60 50 contracts Sold 30 24 23 19 20 10 0 ar David Steven Tim MO