Create an Excel spreadsheet called PRACTICE1 YOURLASTNAME that meets the requirements below. NOTE: Enter all numbers (values) in separate cells from labels. This will permit you to do math with the numbers later.

1. In cell A1, type QUANTITY. In cell B1, type PRICE. In cell C1, type TOTAL. In D1, type ITEM DESCRIPTION.
2. You need to buy 8 pencils for $1.49 each. Enter this information into row 2 in the appropriate cells. In row 3, input information to buy 3 spiral notebooks for $1.09 each.
3. In C2, create a formula to figure out how much you will spend for all the pencils. In C3, create another formula to figure out how much you will spend for all the notebooks. Remember, dont re-type the values (prices or quantities) in your formulas! Instead, refer to the cell locations.
4. In row 4, create a formula to figure out how much all the supplies cost, in total.
5. Format all numbers in column C to show up in Accounting style (with a $ symbol and 2 decimal places).
6. The store is offering a 10% discount on your total purchase! In A5, type this 10% discount rate. In B5, type the label Discount to explain this rate, then in C5, write a formula to figure out how much your purchase will cost after deducting the discount. (CAUTION: make sure your results dont show a negative number if results appear in red or in parentheses or with a minus sign, you may have incorrectly subtracted a larger number from a smaller one! Also, make sure your discounted total is not 10 cents less than the original total but 10 percent less.)
7. Sales tax is 6%. In A6, type this 6% tax rate, in B6 type a label to explain this rate, then, in C6, calculate how much your total discounted purchase will cost including the tax.
8. Create a header with your name on the left. On the right, use the button to input the date (so that if I look at the file tomorrow or next week, it will show that future date).
9. Review your file, making sure all values are clearly labelled and all text is clearly visible.
10. Save the file.
11. Show all the formulas.
12. Use Page Layout, Headings, and checkmark Print to have the row and column numbers appear on a printed page. If necessary, adjust column widths so everything will fit on the front of one page. Print the formula view page to a PDF called PRACTICE1 FORMULAS.
13. Close the Excel file without saving the formula view changes.
14. Submit both files (the Excel and PDF) to the assignment page.