Show:
Formulas & Calculations
Worksheets
This & That
You Do It!
You Do It! Again
100

What calculation does AutoSum perform?

What is adding?

100

Inserting a row

Right click - Insert

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 25 and B4 25

=A3+B4 is 50

100

How to clear Formatting or Contents in a cell

Eraser - clear contents or clear formatting

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

How do you add mutiple sheets

click the plus sign at the bottom of each sheet to add

200

Place text on top of each other to fit in a cell without adjusting the width

Wrap text

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

How do you add decimal points

under number area you pick the icon that represents the decimal points left or right

300

=SUM means

adding all columns for a basic total

300

How do you calculate the Average

(Sum button) =Average

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

What does sequencing mean

It copies a formula into cells and/or completes words such as days of the week, months, etc.

400

How to copy a formula

Drag green box across to copy

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 [white plus cross] select cells 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

How do you insert a pie graph

Insert and pick Pie 

500

How do you change your print settings so you can see your entire sheet on one page

File - Print - No scaling to print all fit columns on one page