In the worksheet below, select the appropriate Excel processes from the drop-down menu to determine the Average Price per Unit of all listed Territories, and the Average Sales per Unit of all listed Territories. c 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Territory Apples Bannanas Cherries Dates Figs Totals Sales Figures for ABC Corporation Units Sold Returns Net Units Sold Price per Unit Sales per Unit 150 10 140 $0.29 $40.60 200 16 184 $0.16 $29.44 176 12 $0.33 $54.12 57 4 53 $0.11 $5.83 48 1 47 $0.47 $22.09 631 43 588 164 Average Price per Unit of All Listed Territories: Average Sales per Unit of All Listed Territories: Average Price per Unit of all listed Territories: =AVERAGE(G4+G8) Average Sales per Unit of all listed Territories: =AVERAGE(G4+G8) =AVERAGE(G5:49) =AVERAGE(G4*G8) =AVERAGE(G4:68) In the worksheet below, select the appropriate Excel processes from the drop-down menu to determine the Average Price per Unit of all listed Territories, and the Average Sales per Unit of all listed Territories. AB C 1 2 Sales Figures for ABC Corporation 3 Territory Units Sold Returns Net Units Sold Price per Unit Sales per Unit 4 Apples 150 10 140 $0.29 $40.60 5 Bannanas 200 16 184 $0.16 $29.44 6 Cherries 176 12 164 $0.33 $54.12 7 Dates 57 4 53 $0.11 $5.83 8 Figs 48 1 47 $0.47 $22.09 9 Totals 631 43 588 10 11 =AVERAGE(H5:H9) 12 Average Price per Unit of All Usted Territories: 13 Average Sales per Unit of All Usted Territories: =AVERAGE(H4+H8) 14 =AVERAGE(H4*H8) Average Price per Unit of all listed Territorie =AVERAGE(H4:H8) 8) Average Sales per Unit of all listed Territories