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?
Date Functions
count the number of cells in a range that contain values or letters
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
LIst
cell that meet a condition set forth in the formula
Lookup Functions
=NOW
What does CountIF do?
Date Functions
count the number of cells in a range that contain values or letters
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
LIst
cell that meet a condition set forth in the formula
Lookup Functions
=NOW
What is used to calculate a period of time?
Date Functions
count the number of cells in a range that contain values or letters
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
LIst
cell that meet a condition set forth in the formula
Lookup Functions
=NOW
If I needed to know the date, what function would I use?
Date Functions
count the number of cells in a range that contain values or letters
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
LIst
cell that meet a condition set forth in the formula
Lookup Functions
=NOW
What would this do? =Days360
Date Functions
count the number of cells in a range that contain values or letters
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
LIst
cell that meet a condition set forth in the formula
Lookup Functions
=NOW
Would would =CountA do?
Date Functions
count the number of cells in a range that contain values or letters
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
LIst
cell that meet a condition set forth in the formula
Lookup Functions
=NOW
What are used to compare a cell value to an array to cells and return a value that matches the location of the value in the array
Date Functions
count the number of cells in a range that contain values or letters
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
LIst
cell that meet a condition set forth in the formula
Lookup Functions
=NOW
What is used to assist in organizing spreadsheet information?
Date Functions
count the number of cells in a range that contain values or letters
Calculates difference in days between two dates
Determine which products need to be re-ordered by displaying YES or NO
LIst
cell that meet a condition set forth in the formula
Lookup Functions
=NOW
Check it!