Font size
WorksheetsSpreadsheet Formulas/Functions
Total questions: 11
Worksheet time: 17mins
What is the formula you would use in cell D2 to find the total cost per item?
=B1*C1
=B1+C1
=B1-C1
=B1/C1
What is the formula or function you would use to get the subtotal?
=sum(D2:D10)
=(D2:D10)
=D2+D3+D4+D5+D6+D7+D8+D9+D10
=D2+D10
How would you calculate the tax in cell D13 ($55.50)
=D12*.06
=D12+.06
=D12-.06
=D12/.06
How would you find the total cell D14?
=D12+D13
=D12*D13
=D12-D13
=D12/D13
How would you find the remaining balance from your budget of $1,000?
=D12-1000
=D13-1000
=D14-1000
What formula would you use the get the total cost (D4)?
=B4*C4
Copy the formula from cell D2 down
=B4+C4
=B4-C4
What label is in cell B1
Item
Quanity
Price per item
Total Cost
What label is in cell A1
Item
Quanity
Price per Item
Total Cost
What label is in cell D1
Item
Quantity
Price per Item
Total Cost
What is the label in cell C1?
Item
Quantity
Price per Item
Total Cost
Match the following labels with the correct formulas/function?
Total Cost
=B2*C2
Subtotal
=sum(D2:D10)
Tax
=D12*.06
Total
=D12+D13
Remaining Balance
=D14-1000
