Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
If you see ###### instead of numbers:
Your cell size is too narrow
The cell will display YES if C6 is 100
SUM
Conditional Formatting
When you want to add several criteria to an IF, and all must be true
Copies a cell's formula or data to other cells
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 Fill Handle
Your cell size is too narrow
The cell will display YES if C6 is 100
SUM
Conditional Formatting
When you want to add several criteria to an IF, and all must be true
Copies a cell's formula or data to other cells
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
One difference in using the Function box to add a function to a cell, vs typing it in the cell yourself:
Your cell size is too narrow
The cell will display YES if C6 is 100
SUM
Conditional Formatting
When you want to add several criteria to an IF, and all must be true
Copies a cell's formula or data to other cells
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
If you want to add a range of cells, use this function:
Your cell size is too narrow
The cell will display YES if C6 is 100
SUM
Conditional Formatting
When you want to add several criteria to an IF, and all must be true
Copies a cell's formula or data to other cells
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
Changing how cells look when they meet a certain criteria is called:
Your cell size is too narrow
The cell will display YES if C6 is 100
SUM
Conditional Formatting
When you want to add several criteria to an IF, and all must be true
Copies a cell's formula or data to other cells
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
In the following spreadsheet formula, what does the YES mean? =IF(C6=100, Yes, No)
Your cell size is too narrow
The cell will display YES if C6 is 100
SUM
Conditional Formatting
When you want to add several criteria to an IF, and all must be true
Copies a cell's formula or data to other cells
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 AND function is used:
Your cell size is too narrow
The cell will display YES if C6 is 100
SUM
Conditional Formatting
When you want to add several criteria to an IF, and all must be true
Copies a cell's formula or data to other cells
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 OR function allows:
Your cell size is too narrow
The cell will display YES if C6 is 100
SUM
Conditional Formatting
When you want to add several criteria to an IF, and all must be true
Copies a cell's formula or data to other cells
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
Check it!
Match it!
Match it!