INSERTING FORMULAS IN EXCEL SPREADSHEETS
Directions: In the spreadsheet below, insert a formula that will calculate the student averages.
If your average is 60, your formula is correct.
To check your formula, CLICK HERE
Directions: In the spreadsheet below, insert a formula that will find the tax and total on the item below. Use 7% as your tax.
If your tax is 1.76 and your total is 26.86, your formula is correct.
To check your formula, CLICK HERE
Directions: In the spreadsheet below, insert a formula that will find the total of all donuts sold Monday through Friday
If your total is 1948, your formula is correct.
To check your formula, CLICK HERE
Directions: You find some things at the store you want to buy. The total of these items is $125.76.
You give the sales clerk $130.00. Insert a formula that will calculate how much the sales clerk
will give you.
If change back is 4.24, your formula is correct.
To check your formula, CLICK HERE
=average(b3:e3) or =sum(b3:e3)/4
Tax =(b3*7%) or =b3*7%
Total =b3+c3
You may have used another formula for the total that worked.
Finding the Total of Donuts Sold
=sum(b3:f3)
In this formula you subtract the total of the items
from the amount you give the sales clerk.
=b3-a3