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 the icon for the SUM function looks like.
What is the "freaky looking E"?
100
______ is the mathematical indicator for addition
What is +
100
The shortcut key for bold
What is CTRL B
200
Columns (up and down) are "named" by these.
What is a letter?
200
___________ is the symbol for division.
What is /
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
________ is the mathematical indicator for subtraction.
What is -
200
The shortcut key for print
What is CTRL P
300
Rows (horizontal cells) are "named" by these.
What are numbers.
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
The text word for addition
What is SUM
300
The shortcut key for Italics
What is CTRL I
400
True or False. Excel 2007 has the capacity of 1,000,000 rows by 16,000 columns.
What is True!
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
The command for looking up data from a "look-up" list
What is VLOOKUP
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
The quick reference for the "Order of Operations"
What is Please Excuse my Dear Aunt Sally or PEDMAS
500
The shortcut key for paste
What is CTRL V