Basic Stuff
Formulas
Functions
Applying Formulas & Functions
Other Spreadsheet Stuff
100
The name for each individual location on a spreadsheet.
What is a cell?
100
All formulas start with this.
What is the equal sign?
100
This function adds all the data in a cell range.
What is the SUM function?
100

The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 7. What function would return the answer 6.


What is =AVERAGE(A1:A6)?


100
This is the correct format for column headings.
What is bold and centered?
200
Columns identified by which one of these: (letter or number)
What is a letter?
200
The order of operations used for calculating.
What is PEMDAS?
200
This function will return the highest number in a cell range.
What is MAXIMUM?
200
The formula that will add the data in cell range D1:D17.
What is =Sum(D1:D17)?
200
This spreadsheet feature will combine a group of cells and center the contents.
What is merge & center?
300
Rows (horizontal cells) are identified by these. A letter or number
What are numbers?
300
Cells must contain this type data in order to calculate.
What are values?
300
A shortcut for a formula.
What is a function?
300
The first item to be calculated in the formula =(B2+C2)/D2
What is B2+C2?
300
A border consisting of a single top border and a double bottom border.
What is an accounting border?
400
The cell address of the cell created by the intersection of Column C and Row 17.
What is C17?
400
The asterisk is the symbol used for this mathematical operation.
What is multiplication?
400
The function that would calculate your grade average.
What is AVERAGE?
400
This mathematical operation would return the difference between two cells.
What is subtraction?
400
This spreadsheet feature will quickly copy a formula to other cells.
What is FILL handle?
500
A group of adjacent cells.
What is a cell range?
500
Data that tells the spreadsheet to perform a calculation.
What is a formula?
500
The function that finds the lowest number in a cell range.
What is MINIMUM?
500

The contents in cells A1 through A6 are 12, 18, 4, 3, 7, and 2. This function would return the answer 18.


What is =MAX(A1:A6)?


500
This spreadsheet feature will arrange data in a specified order (i.e. ascending or descending order).
What is sort?
M
e
n
u