Download the Excel file ' week2_exer.xlsx' and complete the
invoice by using Excel formulas / functions / expressions to do the
calculations on the other worksheets, and convert the final invoice
into an Excel Table on a new worksheet.
Download The Excel File Week2 Exer Xlsx And Complete The Invoice By Using Excel Formulas Functions Expressions To 1 (50.68 KiB) Viewed 43 times
ITEM 10.5" Extra Thick Dinner Plates - 20 count 8" Deep Dessert Plates - 15 count 16 oz. Beverage Cups - 30 count 12 oz. Styrofoam Coffee Cups - 20 count 50 count Plastic Spoons - White 50 count Plastic Forks - White 50 count Plastic Knives - White 100 count Dinner Napkins - Blue 75 count Beverage Napkins - Green TOTAL UNIT PRICE QUANTITY $3.79 15 $3.99 20 $1.29 10 $1.59 15 $2.59 6 $2.69 6 $2.19 6 $1.39 3 $1.19 4 $20.71 85 TAX RATE: 7.5% LINE SUBTOTAL SALES TAX $56.85 $4.26 $79.80 $5.99 $12.90 $0.97 $23.85 $1.79 $15.54 $1.17 $16.14 $1.21 $13.14 $0.99 $4.17 $0.31 $4.76 $0.36 $227.15 $17.04 LINE TOTAL $61.11 $85.79 $13.87 $25.64 $16.71 $17.35 $14.13 $4.48 $5.12 $244.19
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!