Excel 1

Inventory 1 create an inventory value sheet with proper column widths and valur format as given.

Items

Balloon: Quantity:1,735       Unit Price: 0.11         Value

Card:      Quantity: 25                      Unit Price:1.25          Value

Funny Fork: Quantity 336   Unit Price: .79            Value

Oops Egg: Quantity: 605      Unit Price: 1.35         Value

Clown Nose: Quantity: 1,122           Unit Price: .90            Value

Total Value

Create formulas in cell (a) through (e) to multiply the quantity by the unit price to calculate the value. Format the Balloon and Total Value cells in the Value column to show dollars and cents and the four remaining cells, comma and two decimals only create a formula to total these values in cell (f)

Second Part

Inventory 2

Add a fifth column title it Reorder. Use an if statement to print the word “order” if the quantity is below 500 units, or dash if 500 or above. (Hint: use the text “ORDER” and “-“ in the true and false locations in the if function)