Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
The OR function allows:
SUM
Conditional Formatting
The Function box will add the parenthesis for you
Multiple conditions to be used with an IF function when only one needs to be true
The cell will display YES if C6 is 100
Your cell size is too narrow
Range
Copies a cell's formula or data to other cells
The Fill Handle
SUM
Conditional Formatting
The Function box will add the parenthesis for you
Multiple conditions to be used with an IF function when only one needs to be true
The cell will display YES if C6 is 100
Your cell size is too narrow
Range
Copies a cell's formula or data to other cells
One difference in using the Function box to add a function to a cell, vs typing it in the cell yourself:
SUM
Conditional Formatting
The Function box will add the parenthesis for you
Multiple conditions to be used with an IF function when only one needs to be true
The cell will display YES if C6 is 100
Your cell size is too narrow
Range
Copies a cell's formula or data to other cells
In the following spreadsheet formula, what does the YES mean? =IF(C6=100, Yes, No)
SUM
Conditional Formatting
The Function box will add the parenthesis for you
Multiple conditions to be used with an IF function when only one needs to be true
The cell will display YES if C6 is 100
Your cell size is too narrow
Range
Copies a cell's formula or data to other cells
If you want to add a range of cells, use this function:
SUM
Conditional Formatting
The Function box will add the parenthesis for you
Multiple conditions to be used with an IF function when only one needs to be true
The cell will display YES if C6 is 100
Your cell size is too narrow
Range
Copies a cell's formula or data to other cells
Changing how cells look when they meet a certain criteria is called:
SUM
Conditional Formatting
The Function box will add the parenthesis for you
Multiple conditions to be used with an IF function when only one needs to be true
The cell will display YES if C6 is 100
Your cell size is too narrow
Range
Copies a cell's formula or data to other cells
A group of adjacent cells referenced in a formula are called a ____________.
SUM
Conditional Formatting
The Function box will add the parenthesis for you
Multiple conditions to be used with an IF function when only one needs to be true
The cell will display YES if C6 is 100
Your cell size is too narrow
Range
Copies a cell's formula or data to other cells
If you see ###### instead of numbers:
SUM
Conditional Formatting
The Function box will add the parenthesis for you
Multiple conditions to be used with an IF function when only one needs to be true
The cell will display YES if C6 is 100
Your cell size is too narrow
Range
Copies a cell's formula or data to other cells
Check it!
Match it!
Match it!