Question: 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

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 D E G H 1 1 2 3 4 5 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 164 $0.33 $54.12 57 4 53 $0.11 $5.83 48 1 47 $0.47 $22.09 631 43 588 Territory Apples Bannanas Cherries Dates Figs Totals 6 7 8 9 10 11 12 13 14 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 Sales per Unit of all listed Territories: 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 D E G H 1 1 2 3 4 5 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 164 $0.33 $54.12 57 4 53 $0.11 $5.83 48 1 47 $0.47 $22.09 631 43 588 Territory Apples Bannanas Cherries Dates Figs Totals 6 7 8 9 10 11 12 13 14 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 Sales per Unit of all listed Territories
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
