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)
No comments:
Post a Comment