Show:
Basic Stuff
Formulas
Functions
Applying Formulas
Shortcut Keys
100
The name for each square on a spreadsheet.
What is a cell?
100
All formulas start with this.
What is the equal sign?
100
This is what Mrs. T calls the icon for the SUM function.
What is the "freaky looking E"?
100
A B C 1 T-Shirt Cost # Ordered Total Owed 2 10.99 2
What is =A2*B2
100
The shortcut key for bold
What is CTRL B
200
Columns (up and down) are "named" by these.
What is a letter?
200
The way you enter a formula
Type it in yourself
200
It doesn't matter where you click on the spreadsheet, as long as you have chosen the correct function (True or False)
What is FALSE?
200
A B C 1 Cost Sales Tax % Sales Tax Owed 2 $2.75 8.25%
What is =A2*B2
200
The shortcut key for print
What is CTRL P
300
This is what Mrs. T calls the cell reference numbers such as A2 or C17.
What is a bingo number?
300
Formulas must always have these
What are mathematical symbols?
300
You must hit this key to make the function calculate.
What is the enter key?
300
A B C 1 Yards of Fabric Cost Per Yard Total Cost 2 6.5 $3.99
What is =A2*B2
300
The shortcut key for Italics
What is CTRL I
400
This is the main purpose of Excel.
What is to perform math?
400
* is the mathematical symbol for _______
What is multiplication?
400
The only function we've used so far does this for you.
What is addition or SUM?
400
A B C D 1 Cost Sales Tax % Sales Tax Owed Total Cost 2 $15.99 8.25% Find the formulas for C and D
What is =A2*B2 and =A2+C2
400
The shortcut key for double-spacing
What is CTRL 2
500
The icon on the desktop for Excel is this color
What is green?
500
You must hit this to make the formula calculate
What is the enter key?
500
What needs to be around the numbers you want to use in a function?
What are the blinking lines?
500
A B C D E 1 Original $ Monthly Pmt. # of Pmts. Total Paid Finance Charge 2 $16,000 $445.67 60 Find the formulas for D and E
What is =B2*C2 and =D2-A2
500
The shortcut key for paste
What is CTRL V