A B C I E F G H Looking at shipments, at employee performance, and at services required by customers; Quickstove managment performs several analyses. 6 Shipments by Employee Total Value Average Value Count Merrill Frank George Howard AIT CA OR Shipments by Shipping Class Count Total Value Average Value Regular Express Overnite Page 5 Ordered Ship To 1003 AZ 10041 WA 1007 NV 1 1011 UT 1027 CA 1041 MT 10421 1050 1058 UT 1059 AZ 10601 WA 1062 UT 1073 CO 1074 10881 WA 10941 NV 1109 HI 1201 OR 12551 OR 1262 UT 1265 WA 1267 CA 1268 1364 1417UT 1629 CA 1635 co 1661 AZ 1666 OR 16771 WA 1686 CA 1701 Co 1708 AZ 1712| AZ 1718 OR ProductID Product Name 100 QuickStove 100 QuickStove 100 QuickStove 100 QuickStove 100 QuickStove 102 Replacement Fuel Cells 104 Quick Stove Can 104 Quick Stove Can 1041 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 108 QuickStove Fuel Disk 107ISIAC Fuel Cell 106 Stove In A Can 107 SIAC Fuel Cell 107 SIAC Fuel Cell 108 QuickStove Fuel Disk 101 QuickStove Can 101 QuickStove Can 101 QuickStove Can 108 QuickStove Fuel Disk 101 QuickStove Can Ship Class Value Employee | Express $ 68.80 Merrill Express $ 86.00 George Regular $120.39 George Express $120.39 Merrill Overnite $ 17.55 Frank Overnite $ 4.00 Frank Overnite $ 69.98 George Overnite $274.32 Frank Express ($274.32 Frank Regular $ 15.68 Frank Overnite $ 69.98 George Regular $ 60.80 George Overnite $ 34.99 Merrill Overnite $ 19.60 George Overnite $ 4.00 Frank Express I $ 8.00 George Express $ 8.00 Howard Express S 38.00 George Overnite $ 34.99 George Regular $ 102.87 Merrill Express $ 34.99 Merrill Overnite $102.87 Merrill Regular $ 34.99 Merrill Regular $398.89 Frank Overnite $ 37.85 George Express $ 10.00 George Express $ 69.98 Merrill Regular $ 47.50 Merrill Express $ 19.60 Merrill Express $ 31.54 Frank Overnite $ 19.95 Frank Overnite $ 19.95 Merrill Overnite $ 19.95 Merrill Express $ 47.31 | Frank Overnite $ 39.90 Merrill MT Use the COUNTIF function in cell 18 to determine the number of shipments handled by employee Merrill. Copy your function in cell 18 and paste it down to J11 to complete the "Count" column of the "Shipments by Employee" table for individual employees. Use the SUMIF function in cell K8 to determine the value of the shipments handled by employee Merrill. Copy your function in cell K8 and paste it down to complete the "Total Value" | column of the "Shipments by Employee" table for individual employees. Use the AVERAGEIF function in cell L8 to determine the average value of the shipments handled by employee Merrill. | Copy your function in cell L8 and paste it down to complete the "Average Value" | column of the "Shipments by Employee" table for individual employees. Use the appropriate functions in cells J12,K12 and L12 to calculate the overall number of shipments, total value of all shipments and average value of all shipments. Use the COUNTIF function in cell J17 to determine the number of regular shipments. Copy your function in cell J17 and paste it down to complete the "Count" column of the "Shipments by Shipping Class" table. Use the SUMIF function in cell K17 to determine the Total Value of the regular shipments. Copy your function in cell K17 and paste it down to complete the "Total Value" | column of the "Shipments by Shipping Class" table. Use the AVERAGEIF function in cell L17 to determine the average value of the regular shipments. Copy your function in cell L17 and paste it down to complete the "Average Value" column of the "Shipments by Shipping Class" table.. A B C I E F G H Looking at shipments, at employee performance, and at services required by customers; Quickstove managment performs several analyses. 6 Shipments by Employee Total Value Average Value Count Merrill Frank George Howard AIT CA OR Shipments by Shipping Class Count Total Value Average Value Regular Express Overnite Page 5 Ordered Ship To 1003 AZ 10041 WA 1007 NV 1 1011 UT 1027 CA 1041 MT 10421 1050 1058 UT 1059 AZ 10601 WA 1062 UT 1073 CO 1074 10881 WA 10941 NV 1109 HI 1201 OR 12551 OR 1262 UT 1265 WA 1267 CA 1268 1364 1417UT 1629 CA 1635 co 1661 AZ 1666 OR 16771 WA 1686 CA 1701 Co 1708 AZ 1712| AZ 1718 OR ProductID Product Name 100 QuickStove 100 QuickStove 100 QuickStove 100 QuickStove 100 QuickStove 102 Replacement Fuel Cells 104 Quick Stove Can 104 Quick Stove Can 1041 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 108 QuickStove Fuel Disk 107ISIAC Fuel Cell 106 Stove In A Can 107 SIAC Fuel Cell 107 SIAC Fuel Cell 108 QuickStove Fuel Disk 101 QuickStove Can 101 QuickStove Can 101 QuickStove Can 108 QuickStove Fuel Disk 101 QuickStove Can Ship Class Value Employee | Express $ 68.80 Merrill Express $ 86.00 George Regular $120.39 George Express $120.39 Merrill Overnite $ 17.55 Frank Overnite $ 4.00 Frank Overnite $ 69.98 George Overnite $274.32 Frank Express ($274.32 Frank Regular $ 15.68 Frank Overnite $ 69.98 George Regular $ 60.80 George Overnite $ 34.99 Merrill Overnite $ 19.60 George Overnite $ 4.00 Frank Express I $ 8.00 George Express $ 8.00 Howard Express S 38.00 George Overnite $ 34.99 George Regular $ 102.87 Merrill Express $ 34.99 Merrill Overnite $102.87 Merrill Regular $ 34.99 Merrill Regular $398.89 Frank Overnite $ 37.85 George Express $ 10.00 George Express $ 69.98 Merrill Regular $ 47.50 Merrill Express $ 19.60 Merrill Express $ 31.54 Frank Overnite $ 19.95 Frank Overnite $ 19.95 Merrill Overnite $ 19.95 Merrill Express $ 47.31 | Frank Overnite $ 39.90 Merrill MT Use the COUNTIF function in cell 18 to determine the number of shipments handled by employee Merrill. Copy your function in cell 18 and paste it down to J11 to complete the "Count" column of the "Shipments by Employee" table for individual employees. Use the SUMIF function in cell K8 to determine the value of the shipments handled by employee Merrill. Copy your function in cell K8 and paste it down to complete the "Total Value" | column of the "Shipments by Employee" table for individual employees. Use the AVERAGEIF function in cell L8 to determine the average value of the shipments handled by employee Merrill. | Copy your function in cell L8 and paste it down to complete the "Average Value" | column of the "Shipments by Employee" table for individual employees. Use the appropriate functions in cells J12,K12 and L12 to calculate the overall number of shipments, total value of all shipments and average value of all shipments. Use the COUNTIF function in cell J17 to determine the number of regular shipments. Copy your function in cell J17 and paste it down to complete the "Count" column of the "Shipments by Shipping Class" table. Use the SUMIF function in cell K17 to determine the Total Value of the regular shipments. Copy your function in cell K17 and paste it down to complete the "Total Value" | column of the "Shipments by Shipping Class" table. Use the AVERAGEIF function in cell L17 to determine the average value of the regular shipments. Copy your function in cell L17 and paste it down to complete the "Average Value" column of the "Shipments by Shipping Class" table