On the Cities worksheet, in cell I2, enter a function that will calculate the average total cost per city. In cell I3, enter a function that will identify the lowest total cost. In cell I4 enter a function that will return the highest total cost.

8/18/2018 8/23/2018 Ground Transportation Round-trip Shuttle $ Rental Car per Day$ Rental Car Total Summary Trip Costs Average Lowest Highest Departure Date 50 30 $150 Return Date Lodging Base/Night $ Total Base Lodging$ 115 575 COL 95% 110% 125% 140% City 4 Rental Shuttle or City Type Car? Airfare Renta LodgingMeals Destination City Boston Miami Orlando Philadelphia San Antonio Washington DC No Yes Yes No Yes No $36750 $719 633 546 719 546 805 392 299 479 218 469 150 150 50 150 50 375$ 1,511 1,505 1,280 1,623 1,199 1,744 330 285 375 285 420 4