You just started working for a travel agency that specializes in working with cruise companies…
You just started working for a travel agency that specializes in working with cruise companies departing from Miami and travelling to the Caribbean and Mexico/Central America. Carter, your predecessor, created a database in Excel that lists details about each cruise, such as number of days of the cruise, departure date, destination, cruise line, ship name, and posted rates by cabin type. In addition, Carter calculated 10% discounts on Outside and Balcony cabins and discounts for Interior and Deluxe cabins based on these rules:
• 15% discount on Deluxe/Suite cabins for either 4- OR 5-day cruises
• 20% discount on Interior cabins with both (a) 7 or more-day cruise AND (b) 4 rating
• 25% discount on Interior cabins with both (a) 7 or more-day cruise AND (b) 3.5 rating
Open e07b3cruises, and then save it as e07b3cruises_LastnameFirstname. Correct the errors with the discount formula in the Adj-Suite column and in the Adj-Interior column. Insert comments in cells K10 and N10 describing the errors and what you did to correct the errors. Carter also created a Criteria Range to be able to filter records for seven-day cruises to the Caribbean that depart before May 1, 2012, with a rating of either four or five. Correct and document errors in this range, and then perform the advanced filter again, copying the results in the Output Range. Carter created an Adjusted Rate Statistics area using database functions to identify the lowest, highest, and average adjusted rates for the four cabin types. In addition, he calculated the number of cabins meeting the criteria. Correct and document errors in this section. Create a footer with your name, the sheet name, and the file name. Save and close the workbook, and submit based on your instructor’s directions.