Can you do it for me in excel and show me the formula please
9. Format the worksheet to make it easy to read and understand. Calculating Travel Costs at America Travels (50 Points) As a new sales associate at America Travels travel agency, you assist travel agents in finding the best fares for corporate customers. As a high-volume travel agency, America Travels has negotiated several premium discounts with airlines, which you pass business with you. Compared to standard business fares, these discounts can savings and do not have minimum stay requirements. along to your customers who do a large amount of amount to a substantial Convertto, Inc. is a significant customer with a travel department that prices its own fares online and then contacts America Travels to see if it can produce a better rate. Convertto sends an Excel workbook containing a list of proposed trips to America Travels each day by 10 AM via email, and requests price quotes for these trips by noon. Convertto has corporate offices in New York, San Francisco, and London, which is where most of its travel originates. When the Convertto workbook arrives, America Travels sales associates must work hard to enter the information that Convertto requests and return the workbook to the company on time. For several months, America Travels has been working on a more automated method of replying to these inquiries. Another sales associate compiled fare data by flight number and researched airport fees. This information has been set up on separate worksheets in an Excel workbook. Your task is to complete the last piece of the project, which is to use the information on the customer's fare request sheet and automatically calculate the best fares. For this project, assume that all flight numbers are included on the flights list. The following worksheets have already been created in an Excel workbook names Convertto.xlsx: .Requests, which contains a sample request form from Convertto, including the date, traveler's name, flight number, and corporate-rate fare. Flights, which contains a list of flights sorted by flight number and the associated departure city, arrival city, and base fare. . Fees, which contains a table listing fare categories and airport fees associated with ticket prices. These airport fees will be added to the price of each ticket. For example, fares of less than S200.00 fall into fare category 1 and have a $15 airport fee, and fares from $200.00 to $349.99 also fall into fare category 1 bust have a $25 airport fee. Discounts, which contains a two-dimensional table of discount categories based on the fare category and the weekday of the ticket. Your task is to include formulas in the Requests worksheet to provide fare information. All formu- las must work when copied down the column to determine the requested information for each travel request. Complete the following: 9. Format the worksheet to make it easy to read and understand. Calculating Travel Costs at America Travels (50 Points) As a new sales associate at America Travels travel agency, you assist travel agents in finding the best fares for corporate customers. As a high-volume travel agency, America Travels has negotiated several premium discounts with airlines, which you pass business with you. Compared to standard business fares, these discounts can savings and do not have minimum stay requirements. along to your customers who do a large amount of amount to a substantial Convertto, Inc. is a significant customer with a travel department that prices its own fares online and then contacts America Travels to see if it can produce a better rate. Convertto sends an Excel workbook containing a list of proposed trips to America Travels each day by 10 AM via email, and requests price quotes for these trips by noon. Convertto has corporate offices in New York, San Francisco, and London, which is where most of its travel originates. When the Convertto workbook arrives, America Travels sales associates must work hard to enter the information that Convertto requests and return the workbook to the company on time. For several months, America Travels has been working on a more automated method of replying to these inquiries. Another sales associate compiled fare data by flight number and researched airport fees. This information has been set up on separate worksheets in an Excel workbook. Your task is to complete the last piece of the project, which is to use the information on the customer's fare request sheet and automatically calculate the best fares. For this project, assume that all flight numbers are included on the flights list. The following worksheets have already been created in an Excel workbook names Convertto.xlsx: .Requests, which contains a sample request form from Convertto, including the date, traveler's name, flight number, and corporate-rate fare. Flights, which contains a list of flights sorted by flight number and the associated departure city, arrival city, and base fare. . Fees, which contains a table listing fare categories and airport fees associated with ticket prices. These airport fees will be added to the price of each ticket. For example, fares of less than S200.00 fall into fare category 1 and have a $15 airport fee, and fares from $200.00 to $349.99 also fall into fare category 1 bust have a $25 airport fee. Discounts, which contains a two-dimensional table of discount categories based on the fare category and the weekday of the ticket. Your task is to include formulas in the Requests worksheet to provide fare information. All formu- las must work when copied down the column to determine the requested information for each travel request. Complete the following
