*Given the following data in the spreadsheet, write a formula to compute the discount rate (B2) _________________________________________________________ (2 pt) and the final sale price (C2)_______________________________________________(1pt): if the Sale total (before discount) is over $1000, give 20%, less than $1000 but over 500, give 10% discount, below $500, give 5%. *Compute the values of B3 and C4 and fill in the blanks. (0.5 pt each)

Row A B C

1 Sales Price Discount Rate Final Sales Total 2 350 3. 750 ___________ 4 1200 ________________

Write the formula you use in cell C2 (to be copied) to generate a letter grade for each of the following students using the grade scale used in this class: (3 points) _______________________________________________________________ A B C 1 Student Score Grade 2 1 87 _____ 3 2 95 4 3 92 5 4 59 6 5 65

A B D Discount Rat Final Sales Total 2 1 Sale Orice 350 3 750 4 1200 5 6