I am currently stuck on problem numbers 8-14. This came from the book Succeeding in Business with Microsoft Excel 2013 Chapter 5 Case Problem level 2.

12. In cell N3, compare the America Travels total ticket price to the corporate fare that Convertto found. Return a TRUE value if the America Travels price is less than the 14. Save and close the Convertto Travel Quotes.xlsx workbook. Sin da o txo boloodhoudt As part of its product line, CKG Auto has nine basic models, each with different options customers are also becoming increasingly concerned about the yearly onerating expenses plano and features. Although many car buyers are concerned about the initial cost of a car, fare category. In cell 13, this ticket. Copy the formula to cells 14:J6. 8. In a separate area of the Discounts worksheet, create a horizontal lookup table base Fare discount category AA: 0% discount of the published base fare Fare discount category X: 25% discount of the published base fare Fare discount category Y: 50% discount of the published base fare Fare discount category Z: 65% discount of the published base fare 9. In cell K3 of the Requests worksheet, write a formula that determines the discounted fare price (base fare minus discount) of this flight using the table you created in the Discounts worksheet. Fares should be rounded to the nearest dollar. (Hint: Do not use an IF function.) Copy this formula to cells K4:K6. 10. In cell L3, calculate the airport fee based on the fee schedule in the Fees worksheet. Note that the airport fee is based on the discounted fare. Copy this formula to cells 14:16. 11. In cell M3, calculate the total ticket price that America Travels can obtain (discounted fare plus airport fees). Copy this formula to cells M4:M6. corporate fare Convertto was offered. Copy this formula to cells N4:N6. 13. Format your worksheet so that it is easy to read and understand. Level 3 - Creating a Cost Estimate Form for CKG Auto they can expect. They frequently want to compare how much a car costs to run each year $5,000 to purchase a sport might reconside B D G H Less than Corp. Rate? 2 Date Traveler 3 7/22/2016 Frasier John 4 8/1/2016 Simpson, Amanda 5 8/4/2016 Wexel, Thomas 6 8/4/2016 Wang, Robert Flight Corporate No Fare Departure City Arrival City 1013 972 San Francisco Seattle 1079 $ 4285 London LA 1068 $ 457 NY Miami 1002 $ 837 NY Seattle Base Fare $ 272 2 277 665 939 America Fare Discounted Airport Travels Total Weekday Category Discount Fare Fee Ticket Price 6 1 2 3 5 2 5 3 B C D E 1 2 3 4 3 x 5 Discount Category Fare Category Weekday 1 2 1 AA 2 Y Y 3 Y Y 4 Y Z 5 Z Y 6 X 7 Y Y Y Z 6 UNAWN Z AA Z COIN 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22