Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
What would be the best use for an IF Statement?
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
=NOW
=
Return the current date
count the number of cells in a range that contain values or letters
Days360
IF Statements
What would this function do? =NOW
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
=NOW
=
Return the current date
count the number of cells in a range that contain values or letters
Days360
IF Statements
Would would =CountA do?
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
=NOW
=
Return the current date
count the number of cells in a range that contain values or letters
Days360
IF Statements
What symbol does every formula and function start with?
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
=NOW
=
Return the current date
count the number of cells in a range that contain values or letters
Days360
IF Statements
If I needed to know the date, what function would I use?
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
=NOW
=
Return the current date
count the number of cells in a range that contain values or letters
Days360
IF Statements
What would this do? =Days360
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
=NOW
=
Return the current date
count the number of cells in a range that contain values or letters
Days360
IF Statements
What are conditional operators?
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
=NOW
=
Return the current date
count the number of cells in a range that contain values or letters
Days360
IF Statements
If I'm trying to calculate how many days until my birthday, which function would I use?
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
=NOW
=
Return the current date
count the number of cells in a range that contain values or letters
Days360
IF Statements
Check it!
Match it!
Match it!