1 2 A B D E F G H INVOICE 2 Net item No. Quantity Unit Description Unit Pricel Amount Discount Amount 3 J16-3344 10 Each Chips 125.30 4 116-4401 3/Dozen Drives 80.45 5 15-3342 20 Each DVDS 20.05 6 15-1401 3 Each Cables 15.95 7 8 9 10 11 12 1. Create the spreadsheet shown above. Save it as YOURLASTNAME Invoice 13 2. Format the dollar amounts as numbers with 2 decimals and a comma separator 14 3. Calculate the amount by multiplying Quantity by Unit Price. Format as Number 15 with 2 decimals and comma separator. 16 1. Find the Discount: if 10 or more of any items are ordered, there is a 10% discount (multiply by.1); 17 if fewer than 10 are ordered, there is no discount. Format the results with 2 decimals. 18 S. Calculate the Net Amount by subtracting the Discount from the Amount. Format the 19 results as currency. 20 5. Format the spreadsheet attractively. 21 6. Add your name to a custom header. 22 7. Follow your teacher's instructions for printing or dropping off