one excel file

Premuc
Home>Homework Answsers>Mathematics homework help>Numerical analysis homework help

 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)

    • 12 years ago
    • 15
    Report issue
    Answer(1)
    putul
    4.8 (641)
    5.0 (20)
    Chat

    Purchase the answer to view it

    • inventory_report.xlsx
    Bids(0)