Chapter Project 137 Monthly fee A B C D Allotted data per month (GB) Data used (GB) Cost per additional GB of data Monthly cost of hotspot or laptop Number of hotspots or laptops Monthly cost of additional tablet Number of additional tablets Cost of data Cost of additional devices/hotspots Total Cost 2 1 3 4 5 6 7 8 9 10 11 12 13 14 15 16 50 12 1 2 =B8*B7+B10*B9 =B12+B13 $60 $15 $10 $20 =IF(B4<B3,B2,B2+B5*(B4-B3)) 9. Write a paragraph supporting the choice in plans that best meets your needs. 10. How are “if/then” loops similar to a piecewise-defined function? Source: Excel © 2018 Microsoft Corporation. Used with Permission from Microsoft.
RkJQdWJsaXNoZXIy NjM5ODQ=