Table 1 shows Apple's online orders for the last week. 

•When shoppers place an online order, several "recommended products" (upsells) are shown as at checkout an attempt to upsell

•See table 2 in cell N2 for a list of products that Apple upsells at checkout.

•Upsells, however, will not be shown if the shopper has added either the iPad Mini , iPad Pro, Special Offer or iPhone7, Special Offer into the their shopping cart. For the purpose of this analysis, any orders containing these products are considered ineligible transactions. All other orders are considered eligible transactions.

•You are tasked with providing a report to management about last week's eligible transactions.

•Construct formulas to answer the five questions to the right of the data table (N14:N22).

  

Table 1. Apple Online Orders for the Week of January 1-7, 2017 Order # - Product 1 I Product 2 T Product 3 T Product 4 T Product 5 - Product 6 I Product 7 - Product 8 - Product 9 2 iPad Pro AppleCare USB Car Charger ook iPad Air Smart Battery Case iMac Apple Watch iPhone7 USB Car Charger USB Car Charger 3 iPad Pro AppleCare ook iPad Air iMa Smart Battery Case Apple Watch iPhone7 iPad Pro AppleCare iPad Air iMac Smart Battery Case Apple Watch iPhone7 5 iPad Pro USB Car Charger aook iPad Air Smart Battery Case Apple Watch iPhone7 7 AppleCare USB Car Charger iPad Air Smart Battery Case Apple Watch iPhone7 8 iPad Pro AppleCare ook iPad Air iMac iPhone7 9 Smart Battery Case AppleCare USB Car Charger iPad Air iMac iPhone7 10 iPad Pro iPad Air iMac Apple Watch iPhone7 11 AppleCare USB Car Charger Smart Battery Case Apple Watch iPhone7 12 AppleCare USB Car Charger Smart Battery Case iMac iPhone7 13 AppleCare USB Car Charger iMac Smart Battery Case iPhone7 AppleCare AppleCare USB Car Charger USB Car Charger 14 iPad Air Smart Battery Case iPhone7 15 iPad Air Smart Battery Case iPhone7 USB Car Charger USB Car Charger 16 iPad Pro AppleCare Smart Battery Case iPhone7 iPad Pro AppleCare USB Car Charger 17 Smart Battery Case iPhone7 18 AppleCare iPhone 6s Smart Battery Case iPhone7 19 AppleCare Smart Battery Case Apple Watch iPhone7 20 iPad Pro iPad Air iMac iPhone7 USB Car Charger USB Car Charger 21 Smart Battery Case iMac iPhone7 22 Smart Battery Case, Sp iMac iPhone7 25 USB Car Charger iPad Air Smart Battery Case, Sp iPhone7 26 AppleCare ook Smart Battery Case, Sp iPhone7 AppleCare AppleCare 27 MaBook Smart Battery Case, Sp iPhone7 USB Car Charger USB Car Charger USB Car Charger 28 Smart Battery Case, Sp iPhone7 29 AppleCare Smart Battery Case, Sp iPhone7 30 AppleCare Smart Battery Case, Sp iPhone7 AppleCare AppleCare 31 USB Car Charger Smart Battery Case, Sp iPhone7 USB Car Charger USB Car Charger USB Car Charger 32 Smart Battery Case, Sp iPhone7 33 AppleCare Smart Battery Case, Sp iPhone7 34 AppleCare Smart Battery Case, Sp iPhone7 AppleCare AppleCare USB Car Charger USB Car Charger USB Car Charger USB Car Charger 35 Smart Battery Case, Sp iPhone7 36 Smart Battery Case, Sp iPhone7 AppleCare AppleCare 37 Smart Battery Case, Sp iPhone7 38 Smart Battery Case, Sp iPhone7