ROTECTED VIEW Be cavefulles from the Internet can contain viuses. Unless you need to ndit, it's safler to stay in Prodected View.Enable Editing A clothing retailer gives you 10 points for every $1 spent, and you can trade in 2,350 points for a $15 gft certificate. Eddie Bauer Shopping Spree Iteres Cost Total Cost Points L Polo Shirt a) The spreadsheet lists purchases and their prices. Create formulas which compute the cost of each item and the points you get from each item. 5 135.00 5219.00 19.99 s 75.00 4 Merrell Shoes Snowline Jacket 7 Cloud Layer Fleece b.) Compute the total cost of the order and the total number of points from the order Full Dip Hoodie 0 Wrinkle Free Oxfor $ 70.00 55.00 Totals: c-) Compute how many $15 gft certificates you will get from this order and the total value of these gift certificates. Note: you cannot get a fractional gift certificate so use the INT function which gives the integer part of a number (effectively it rounds down). Format with er decimal places Gift Certificates: Value of Gift Certificates: Money SpenValue of Gift cestificates d) What is the ratio of money spent to the value of the gift certificates? Enter a formula in cell 121 for this ratio with the second quantity scaled to one. 82 EddieB