Show:
Basic Stuff
Formulas
Functions
Applying Formulas
Terminology
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
Finds the largest number in a cell range.
What is the Max or Maximum function?
100
Write a formula that adds the range of cells A13 to F13.
What is =Sum(A13:F13)
100
Data that has the potential for being used in a calculation.
What is value?
200
Columns (up and down) are "named" by these.
What is a letter?
200
___________ is the symbol for division.
What is /
200
A short cut for a formula.
What is a function?
200
Write a formula multiplying the cell D10 and the cell F10.
What is =D10*F10
200
Data that is NOT used in a calculation.
What is label?
300
Rows (horizontal cells) are "named" by these.
What are numbers.
300
The order of operations.
PEMDAS
300
You must hit this key to make the function calculate.
What is the enter key?
300
Write a formula dividing B12 by the sum of the cell range D12 through D30.
What is =B12/Sum(D12:D30)
300
Data that tells the software to perform a calculation.
What is a formula?
400
True or False. Spreadsheets organize, analyze, and calculate data.
What is True!
400
* is the mathematical symbol for _______
What is multiplication?
400
This function adds all the cells in cell range.
What is the SUM function?
400
Write a formula that will give the average in the range of cells from A1 to A25
What is =Average(A1:A25)?
400
A group of adjacent cells.
What is a cell range?
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
You must have this in order to use a function.
What is a cell range?
500
Write a formula to add cell B3 to cell F3.
What is =B3+F3?
500
The specific location of a cell.
What is the cell address?