Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
If someone wanted to return the first 5 characters in a cell to a different cell, they would use
IF
SUBSTITUTE
arrows
NOW
page layout
control
COUNTIF
LEFT
you can sort and filter a table using these (located on the table):
IF
SUBSTITUTE
arrows
NOW
page layout
control
COUNTIF
LEFT
which of these returns a value based on whether an argument is true or false?
IF
SUBSTITUTE
arrows
NOW
page layout
control
COUNTIF
LEFT
which of the following functions uses a criteria to count the number of items in a range?
IF
SUBSTITUTE
arrows
NOW
page layout
control
COUNTIF
LEFT
Which of the following is NOT a function we used this chapter?
IF
SUBSTITUTE
arrows
NOW
page layout
control
COUNTIF
LEFT
which function returns the current date and time?
IF
SUBSTITUTE
arrows
NOW
page layout
control
COUNTIF
LEFT
to group sheet tabs together, use this key
IF
SUBSTITUTE
arrows
NOW
page layout
control
COUNTIF
LEFT
which of the following tabs contain many of the same options as the print screen?
IF
SUBSTITUTE
arrows
NOW
page layout
control
COUNTIF
LEFT
Check it!