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:
16
Your cell size is too narrow
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
Conditional Formatting
The Function box will add the parenthesis for you
SUM
Range
A group of adjacent cells referenced in a formula are called a ____________.
16
Your cell size is too narrow
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
Conditional Formatting
The Function box will add the parenthesis for you
SUM
Range
In the following spreadsheet formula, what is the CONDITION? =COUNTIF(B2:B25;16)
16
Your cell size is too narrow
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
Conditional Formatting
The Function box will add the parenthesis for you
SUM
Range
Changing how cells look when they meet a certain criteria is called:
16
Your cell size is too narrow
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
Conditional Formatting
The Function box will add the parenthesis for you
SUM
Range
One difference in using the Function box to add a function to a cell, vs typing it in the cell yourself:
16
Your cell size is too narrow
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
Conditional Formatting
The Function box will add the parenthesis for you
SUM
Range
If you want to add a range of cells, use this function:
16
Your cell size is too narrow
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
Conditional Formatting
The Function box will add the parenthesis for you
SUM
Range
In the following spreadsheet formula, what does the YES mean? =IF(C6=100, Yes, No)
16
Your cell size is too narrow
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
Conditional Formatting
The Function box will add the parenthesis for you
SUM
Range
The OR function allows:
16
Your cell size is too narrow
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
Conditional Formatting
The Function box will add the parenthesis for you
SUM
Range
Check it!