Cello Worldwide Current date: Customer ID Location Customer Since CS-104 N 2016/03/12 CS-212 SW 2015/02/16 CS-606 SE 2017/12/15 CS-418 N 2020/04/17 CS-192 SW 2020/11/06 CS-202 SW 2019/04/15 CS-301 SE 2018/02/25 CS-452 N 2018/10/22 CS-127 N 2017/06/12 CS-228 SW 2020/07/01 CS-119 N 2017/04/14 CS-220 SE 2018/11/04 CS-326 N 2016/03/20 CS-401 N 2017/10/14 Business Customers Years Wireless Plan Type Discount? New Contract? Free Phone? N Talk Only Y Unlimited Y Select Y Select Y Unlimited Y Unlimited Y Select Y Select Y Select Y Unlimited Y Unlimited N Talk Only Y Unlimited Y Select a. 14. Cello Worldwide offers a discount to customers who have been with the company for at least four years. Determine whether each customer qualifies for a discount as follows: In cell H5, enter a formula using the IF function that tests whether the number of years is greater than or equal to 4. If it is, display "Y" in cell H5. If it is not, display "N" in cell H5. b. Fill the range H6:H18 with the formula in cell 15.1 15. Kamal plans to offer new, more favorable contracts to business customers who are now receiving a discount and use wireless services. Determine whether each customer should receive a new contract as follows: In cell 15, enter a formula using the AND function that tests whether the Wireless value is equal to "Y" and whether the Discount value is equal to "Y". b. Fill the range 16:118 with the formula in cell 15. 16. Kamal also plans to offer a free mobile phone to customers with businesses in northern Texas using an Unlimited plan. Determine whether each customer should receive a free phone as follows: In cell 35, enter a formula using the OR function that tests whether the location is equal to "N" or whether the plan type is equal to "Unlimited". b. Fill the range 16:J18 with the formula in cell 35. a. a. Pivot Tables Pictures Models My Add-ins Bing People Maps Graph Add-ins Recommended Charts Tables Illustrations 16 X ='Business Customer Analysis''Business Customer Analysis'!P16.12 B C E F G H K Cello Worldwide Current date: 2021/05/28 5 7 3 0 Customer ID CS-104 CS-212 CS-606 CS-418 CS-192 CS-202 CS-301 CS-452 CS-127 CS-228 CS-119 CS-220 CS-326 CS-401 Location N SW SE N SW SW SE N N SW N SE N Business Customers Customer Since Years Wireless Plan Type Discount? New Contract? Free Phone? 2016/03/12 -'Business Customer Analysis'!'Business Customer Analysis'!P16L12 2015/02/16 Y Unlimited 2017/12/15 Y Select 2020/04/17 Y Select 2020/11/06 Y Unlimited 2019/04/15 Y Unlimited 2018/02/25 Y Select 2018/10/22 Y Select 2017/06/12 Y Select 2020/07/01 Y Unlimited 2017/04/14 Y Unlimited 2018/11/04 N Talk Only 2016/03/20 Y Unlimited 2017/10/14 Y Select 1 12 13 14 15 16 17 18 19 20 21 N 22 23