Formulas & Calculations
Worksheets
This & That
You Do It!
You Do It! Again
100
What calculation does AutoSum perform?
What is adding?
100
There are these many worksheets in a workbook.
What is 3?
100
Explain how to rename a worksheet.
Right mouse click on the worksheet tab and type the name.
100
Add the numbers in cells A3 and B4
=A3+B4
100
Determine the cost of these items: Gum - .79 Pretzels - 1.25 Soda - .99
$3.03
200
Every calculation must begin with this . . .
What is the = Equals Sign?
200
Explain how to delete the entire contents of a cell.
Press the Delete key on the Keyboard.
200
Explain what does double-clicking between column letters do?
Resizes the column to accommodate the text.
200
Multiply numbers in cells C6 and D8
=C6*D8
200
If one box of cereal costs $2.67 - how much will 3 cost?
8.01
300
This is the symbol to multiply.
What is asterik? *
300
Explain how columns and rows are identified in Excel.
Columns are Letters and Rows are Numbers.
300
In our computer class, how many numbers should be after the decimal point?
2
300
The tax rate is 6.5% - the subtotal $43.16 How much is the tax? Be sure to reduce the decimal to 2 places.
2.81
300
You purchased 32 cupcakes for your class. The total cost was 13.76. How much did each cupcake cost?
.43
400
What is the symbol used to divide?
What is slash? /
400
Why is the formula bar important? What does it display?
The calculations in the cell.
400
Explain what the Auto Fill handle does.
It copies a formula into cells and/or completes words such as days of the week, months, etc.
400
Sally earns $4.25 an hour babysitting. How much will she earn for 3.5 hours? Decrease to 2 decimal places.
14.88
400
Determine Amber's current English grade. Her grades for far are: 76, 89, 93, 88
86.5 or 87%
500
Explain how Total a calculation when using a subtotal and tax.
Add the subtotal and tax.
500
Explain how to Merge & Center a title across columns A-F. Your answer must be exact to get these points!
Highlight the title and using the wide [hospital cross] select cells A-F and click the Merge & Center button.
500
Explain what needs to be done with the following number to be reduced to 2 decimal places: 1.25666
The decrease decimal button needs to be clicked 3 times.
500
What is the total amount when the subtotal is $47.89 and tax amount is 60 cents?
48.49
500
What is the total cost of a new computer with tax? Computer - $1,113.00 Tax - $77.91
$1,190.91
M
e
n
u