Please show formula!
How can you use Excel to compute the value of your algebraic formula for the first request? 10. In cell L3 of the Requests worksheet, use the VLOOKUP function to retrieve the airport fee based on the fee schedule in the Fees worksheet. Note that the airport fee is based on the discounted fare. Copy the formula down to cell L6. Check Figure: Cell L4 = $100.00 Figure Sense: How should you use the VLOOKUP function to complete the task for the first cell? 11. In cell M3 of the Requests worksheet, calculate the total ticket price that Jayhawks in Flight can obtain (discounted fare plus airport fee). Copy the formula down to cell M6. Check Figure: Cell M3 = $297.00 Figure Sense: What Excel expression can be used to calculate the total ticket price for the first cell? 12. In cell N3 of the Requests worksheet, use a formula to compare the Jayhawks in Flight total ticket price to the corporate fare that Rock Chalk, Inc. found. Return TRUE if the Jayhawks in Flight price is less than the corporate fare that Rock Chalk, Inc. was offered. Return FALSE if the Jayhawks in Flight price is not less than the corporate fare that Rock Chalk, Inc. was offered. Do not write an IF statement! Copy the formula down to cell No. Figure Sense: What Excel expression can be used to determine if it is TRUE that the Jayhawks in Flight price is less than the corporate fare? How can you check to make sure that your answers are correct? 13. Type your first and last name into the center section of the custom header of the Requests worksheet. 14. Make the Requests tab the active worksheet, save and close your file, and use the Excel 6 link on Blackboard to submit your work. 19 IX fx D E F G H K L M N C 1 1 Corporate Request Form Arrival City Base Fare Weekday Fare Category Discount Discounted Fare Airport Fee Jayhawks in Flight Total Ticket Price Less than Corporate Fare? 1 Corporate Fare Departure City 2 3 $ 972.00 San Francisco 4 $ 4,285.00 London 5 $ 457.00 New York 6 $ 837.00 New York 7 7 Seattle Los Angeles Miami Seattle 3 $ 272.00 $ 2,277.00 $ 665.00 $ 939.00 1 2 5 AA Y Y $ $ $ $ $ 272.00 1,139.00 333.00 704.00 2 6 3 A1 IX fx Fare Category A B B C D E F 1 2 3 4 5 Fare Category Ticket Price Airport Fee 1 $ $ 15.00 1 $ 200.00 $ 25.00 2 $ 350.00 $ 35.00 2 $ 500.00 $ 40.00 2 $ 700.00 $ 50.00 3 $ 900.00 $ 60.00 3 $ 1,100.00 $ 100.00 3 $ 1,400.00 $ 125.00 6 7 0 00N 8 9 10 11
