Spreadsheet Formulas/Functions

What is the formula you would use in cell D2 to find the total cost per item?

a

=B1-C1

=B1/C1

=B1+C1

=B1*C1

What is the formula or function you would use to get the subtotal?

a

c

=(D2:D10)

=D2+D10

=sum(D2:D10)

=D2+D3+D4+D5+D6+D7+D8+D9+D10

How would you calculate the tax in cell D13 ($55.50)

a

=D12-.06

=D12*.06

=D12/.06

=D12+.06

How would you find the total cell D14?

a

=D12*D13

=D12+D13

=D12-D13

=D12/D13

How would you find the remaining balance from your budget of $1,000?

c

=D12-1000

=D13-1000

=D14-1000

What formula would you use the get the total cost (D4)?

b

a

Copy the formula from cell D2 down

=B4*C4

=B4-C4

=B4+C4

What label is in cell B1

b

Price per item

Quanity

Item

Total Cost

What label is in cell A1

a

Price per Item

Total Cost

Item

Quanity

What label is in cell D1

d

Quantity

Total Cost

Price per Item

Item

What is the label in cell C1?

c

Price per Item

Item

Total Cost

Quantity