A cloining retailer sives you 10 points for every $1 sperit, and
Eckdie Bauer Shopping Spree
you can tracke in 2,550 points for $15 gift certificate.
3 $ 50,00
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.
Cloud Layer Fleece
b.) Compute the total cost of the order and the total number of points From the order.
Full Zip Hoodle
10 Wrinkde Free Oxford
c.) Compute how many $15 gift certificates you will get from this order and the total value of
these Bift certificates. Note: you cannot get a fractional gift certificate so use the INT function
whichgives the inieger pant of number (effectively Hrounds cown). Format with vero decimal
Value ofGift Cert
Value of Gift Certificates
d.) What is the ratio of money spent to the valueof the gift certificates? Enter a formula incel
12.1 for this ratio with the second quantity staled to one.
These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction
of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice.
Unethical use is strictly forbidden.