You are analyzing several airline carriers to use for your company's corporate travel. On sheet Flights you have compiled information regarding the number of flights from Columbus to certain key cities your employees frequently travel. On sheet Analysis you will be analyzing this information. Sheet Fares contains data on roundtrip airfares from Columbus to the other destinations. Sheet Discounts contains discounts each airline is offering. You will be using this workbook with multiple worksheets in it to compare these costs and to calculate possible discounted fares. Download the Excel start file to begin your work. Notice that this start file only includes the data shaded in gray or data that is given to you in it. You will be inputting proper formula or functions for the remaining data in the unshaded cells by answering the following questions using formula or functions and cell references from this workbook. You will input your formula or functions in the proper worksheet, NOT in this file. Remember to start all formula or functions with an equal (=) sign and to always use cell references where possible. Only use a $ if necessary when copying formula or functions down or across. Also remember to use the worksheet name, then a !, then the cell value wen referencing a cell that is not in the current worksheet. D 1 Number of Flights From Columbus to Destination Flight Frequency From Columbus to Destination Airline America West Boston New York Chicago Boston New York Chicago 7 6 5 Seldom Seldom Seldom 4 American 1 8 4 Seldom Seldom Continental Delta 1 4 10 Seldom Seldom 0 0 0 Never Never Seldom Occasionally Never Flights Flights From Columbus to Destination D Airline Boston New York 3 America West Available Available Chicago Available All Locations At Least Flies to at Least Martha Will 1 Location 2 Locations Fly All At least One At Least 2 Will Fly 4 American 5 Continental 6 Delta Available Available Available Available All At least One At Least 2 Will Fly Available Available All Not Available Not Available Not Available Not All At least One None At Least 2 Less than Two Will Fly Will Not Fly 1 Analysis 1 Airline Fare From Columbus to Destination F Discounted Fare G 2 Airline Boston New York Chicago Boston New York Chicago 3 America West $250.00 $300.00 $450.00 $212.50 $255.00 $382.50 4 American $225.00 $275.00 $500.00 $202.50 $247.50 $450.00 5 Continental $210.00 $350.00 $350.00 $193.20 $322.00 $322.00 6 Delta $275.00 $310.00 $475.00 $261.25 $294.50 $451.25 Fares Fare Discounts Airline: Continental Airline: Delta 8% 5% 2 Airline: America West Airline: American 15% Discounts 10%