50.1K

Verified Solution

Link Copied!

I need help

Instructions:

1. Build the DiscountPercent table, the SalesTaxPercent table, and the ZoneShippingFee table on their respectively named worksheets.

2. Be sure all formulas are copyable:

Discount is the Invoice Amount times the Discount% from the DiscountPercent table.

Sales Tax is the (Invoice Amount minus the Discount) times the Sales Tax% from the SalesTaxPercent table.

Shipping Fee is the Shipping Fee amount from the ZoneShippingFee table.

Total Due is the Invoice Amount minus the Discount plus the Sales Tax plus the Shipping Fee.

Total all relevant columns (already shaded).

Format worksheet appropriately as Accounting with 2 decimals and no dollar sign ($) as already shown in Column A.

3. Upload the completed workbook file.

1ABC Company Sales Invoice Register (type your name here) 4 (Enter system date/time function) 5 Name 6 Jello, Inc 7 First Bank 8 Einstein, LLC 9 Wison Fine Art 10 Zp Tools 11 Access Co. 12 Disk Frame 13 Picture Perfect 14 Wall Border Co 15 Hershey, Inc 16 Pringles Chips 17 Printer Inc 18 FAO Swish Invoice Amount Zone State Discount Sales Tax Shipping Fee Total Due 895.00 A MO 5,230.00F CO 3,240.00C MO 82.00 B AK 95.00 C CO 300.00 A KS 00.00 D KY 785.00 B 1,150.00 AMO 852.00 C KS 2,185.00 E 00.00 F ,500.00AKS 20 Totals 24 1, Build the DiscountPercent table, the Sales TaxPercent table, and the ZoneShippingFee table on their respectively named worksheets 25 2. Be sure all formulas are copyable 26 Discount is the Invoice Amount tires the Discount% from the DiscountPercent table 27 Sales Tax is the (invoice Amount minus the Discount) times the Sales Tax% from the SalesTaPercent table 28 Shipping Fee is the Shipping Fee amount from the ZoneShippingFee table 29 Total Due is the Invoice Amount minus the Discount plus the Sales Tax plus the Shipping Fee 30 Total all relevant columns (already shaded) 31 Format worksheet appropriately as Accounting with 2 decimals and no dolar sign ($) as already shown in Column A 32 3. Upload the completed workbook file 34 Check figure for H20: 20,650.17 1ABC Company Sales Invoice Register (type your name here) 4 (Enter system date/time function) 5 Name 6 Jello, Inc 7 First Bank 8 Einstein, LLC 9 Wison Fine Art 10 Zp Tools 11 Access Co. 12 Disk Frame 13 Picture Perfect 14 Wall Border Co 15 Hershey, Inc 16 Pringles Chips 17 Printer Inc 18 FAO Swish Invoice Amount Zone State Discount Sales Tax Shipping Fee Total Due 895.00 A MO 5,230.00F CO 3,240.00C MO 82.00 B AK 95.00 C CO 300.00 A KS 00.00 D KY 785.00 B 1,150.00 AMO 852.00 C KS 2,185.00 E 00.00 F ,500.00AKS 20 Totals 24 1, Build the DiscountPercent table, the Sales TaxPercent table, and the ZoneShippingFee table on their respectively named worksheets 25 2. Be sure all formulas are copyable 26 Discount is the Invoice Amount tires the Discount% from the DiscountPercent table 27 Sales Tax is the (invoice Amount minus the Discount) times the Sales Tax% from the SalesTaPercent table 28 Shipping Fee is the Shipping Fee amount from the ZoneShippingFee table 29 Total Due is the Invoice Amount minus the Discount plus the Sales Tax plus the Shipping Fee 30 Total all relevant columns (already shaded) 31 Format worksheet appropriately as Accounting with 2 decimals and no dolar sign ($) as already shown in Column A 32 3. Upload the completed workbook file 34 Check figure for H20: 20,650.17

Answer & Explanation Solved by verified expert

See Answer