TextBox 1 4 f B D E F G H J K L M N O P Q R S T U V W X Y z AB AC Transportation Weekly Trip Report 1 Average Miles per Trip Lowest Miles Driven 2 TRIP DATA 3 Number of Trips 4 Highest Miles Driven 5 CAPACITY DATA 6 Most Frequent Size 7 Highest Capacity 8 FUEL AND SALES DATA 9 Total Fuel Cost 10 Dollars Billed Average Capacity per Trip Lowest Capacity Fuel Cost per Gallon Current Charge per Mile $2.67 $0.54 1. Merge and Center Title, Fill Color Blue, Font Color White 2. Using the Countlf function, in Cell C3 calculate the number of trips. 3. Using the Max, Min, and Average function, calculate the information in cells C4, G3 and G4. 4. Using the Mode function, calculate the most frequent size in cell C6 5. Using the Min function, calculate the lowest capacity in cell G7. 6. In Cell C9, Calculate the Total Fuel Cost by totalling Fuel in Gallons multiplied by the Fuel Cost per Gallon. 7. In Cell C10, Calculate the Dollars Billed by totalling the Miles Driven multiplied by the Current Charge Per Mile 11 TRIP DETAIL Trailer 12 Number Size 13 85622 22 14 89653 53 15 87342 42 16 89853 53 17 85722 22 18 85522 22 19 87242 42 20 87442 42 21 89753 53 22 89853 53 23 87442 42 24 89953 53 25 85722 22 26 89653 53 27 85822 22 89853 29 89753 53 30 85822 22 31 87442 42 32 87342 42 33 89753 53 34 89653 53 35 85822 22 36 89753 53 37 89953 53 38 89853 53 39 85722 22 40 87342 42 41 87242 42 42 85822 22 43 89653 53 44 87442 42 45 89753 53 46 89953 53 47 87142 42 48 87142 42 49 87342 42 50 87442 42 Miles Driven Capacity 650 98% 350 45% 400 60% 400 95% 220 97% 775 95% 600 82% 220 75% 480 60% 900 85% 220 84% 600 70% 225 91% 350 40% 875 91% 950 70% 850 60% 1250 98% 200 96% 750 85% 750 81% 950 50% 350 95% 1200 60% 300 80% 1100 40% 365 99% 850 88% 485 87% 900 98% 450 95% 850 70% 740 50% 185 93% 220 75% 1100 98% 150 80% 800 78% in Gallons 43.3 35.0 33.3 40.0 14.7 51.7 50.0 18.3 48.0 90.0 18.3 60.0 15.0 35.0 58.3 95.0 85.0 83.3 16.7 62.5 75.0 95.0 23.3 120.0 30.0 110.0 24.3 70.8 40.4 60.0 45.0 70.8 74.0 18.5 18.3 91.7 12.5 66.7 Sheet1 + Ready EL - + 90% TextBox 1 4 f B D E F G H J K L M N O P Q R S T U V W X Y z AB AC Transportation Weekly Trip Report 1 Average Miles per Trip Lowest Miles Driven 2 TRIP DATA 3 Number of Trips 4 Highest Miles Driven 5 CAPACITY DATA 6 Most Frequent Size 7 Highest Capacity 8 FUEL AND SALES DATA 9 Total Fuel Cost 10 Dollars Billed Average Capacity per Trip Lowest Capacity Fuel Cost per Gallon Current Charge per Mile $2.67 $0.54 1. Merge and Center Title, Fill Color Blue, Font Color White 2. Using the Countlf function, in Cell C3 calculate the number of trips. 3. Using the Max, Min, and Average function, calculate the information in cells C4, G3 and G4. 4. Using the Mode function, calculate the most frequent size in cell C6 5. Using the Min function, calculate the lowest capacity in cell G7. 6. In Cell C9, Calculate the Total Fuel Cost by totalling Fuel in Gallons multiplied by the Fuel Cost per Gallon. 7. In Cell C10, Calculate the Dollars Billed by totalling the Miles Driven multiplied by the Current Charge Per Mile 11 TRIP DETAIL Trailer 12 Number Size 13 85622 22 14 89653 53 15 87342 42 16 89853 53 17 85722 22 18 85522 22 19 87242 42 20 87442 42 21 89753 53 22 89853 53 23 87442 42 24 89953 53 25 85722 22 26 89653 53 27 85822 22 89853 29 89753 53 30 85822 22 31 87442 42 32 87342 42 33 89753 53 34 89653 53 35 85822 22 36 89753 53 37 89953 53 38 89853 53 39 85722 22 40 87342 42 41 87242 42 42 85822 22 43 89653 53 44 87442 42 45 89753 53 46 89953 53 47 87142 42 48 87142 42 49 87342 42 50 87442 42 Miles Driven Capacity 650 98% 350 45% 400 60% 400 95% 220 97% 775 95% 600 82% 220 75% 480 60% 900 85% 220 84% 600 70% 225 91% 350 40% 875 91% 950 70% 850 60% 1250 98% 200 96% 750 85% 750 81% 950 50% 350 95% 1200 60% 300 80% 1100 40% 365 99% 850 88% 485 87% 900 98% 450 95% 850 70% 740 50% 185 93% 220 75% 1100 98% 150 80% 800 78% in Gallons 43.3 35.0 33.3 40.0 14.7 51.7 50.0 18.3 48.0 90.0 18.3 60.0 15.0 35.0 58.3 95.0 85.0 83.3 16.7 62.5 75.0 95.0 23.3 120.0 30.0 110.0 24.3 70.8 40.4 60.0 45.0 70.8 74.0 18.5 18.3 91.7 12.5 66.7 Sheet1 + Ready EL - + 90%