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