Listed below is the Price List for the products sold by Exercise Unlimited, LLC located at $310$ Main Street, Waukesha, WI $53189.$ When a customer$$s order is shipped, the Item # and Quantity of each item sold is entered into an invoice.

Item #

Product Description Unit Price

$100$ T$-$shirts $25\mathrm{.}10$

$101$ Tank Tops $12\mathrm{.}18$

$102$ Sweat Shirts $45\mathrm{.}00$

$200$ Tennis Shoes $80\mathrm{.}87$

$210$ Socks $13\mathrm{.}62$

$300$ Sweat Pants $43\mathrm{.}46$

The customers of the business reside in two different states, Wisconsin and Illinois, so they pay different sales taxes. If the customer resides in Wisconsin $($WI$),$ the sales tax rate is $5\%.$ If the customer resides in Illinois $($IL$),$ the sales tax rate is $6\mathrm{.}25\%.$

Requirements:

$$ Enter the Price List on a worksheet in Excel. Name the tab PriceList.

$$ Create an invoice on a separate worksheet where you can enter the Item # and Quantity sold. Allow for fifteen lines for product sales. A Data Validation List must be used for the Item #$.$ Name the tab Invoice. The invoice must be your own design and not a template from the internet.

$$ Use the VLOOKUP function to look up the product description and unit price of each item sold.

$$ Use the IF function to calculate the appropriate sales tax based upon which state the customer orders from. If the customer$$s state is changed, the sales tax must automatically calculate. A Data Validation List must be used for the State.

$($Over$)$

$$ Use formulas to calculate totals for each line, the subtotal, and the invoice total.

$$ Use the IFERROR function to eliminate any error messages in empty cells.

$$ Use professional formatting throughout your Invoice, including consistent number formats, borders, underlining, cell styles, etc.

$$ You are expected to create a real$-$world looking invoice that would include items such as date, invoice number, payment terms, shipping method, etc.

Required Columns:

Item #

Product Description

Quantity

Unit Price

Amount

Required Rows $($on bottom of invoice$)$:

Subtotal

Sales Tax

Total

When your Invoice template is completed, enter the following sale to Fashion Unlimited, Inc., $200$ Main Street, Oconomowoc, WI $53066.$

Item # Quantity

$30050$

$10135$

$10240$

$20028$

$21012$