Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
You can used the Insert Function dialog box to find a specific function. In the ___ box, type a brief description of what you want to do. Then click Go.
=SUM(D5:D17)
NOW()
Search for a function
=B3+B4
=AVERAGE(E4:E9)
future value
REPT
mathematical
The ___ function repeats the text in the specified cell a specified number of times
=SUM(D5:D17)
NOW()
Search for a function
=B3+B4
=AVERAGE(E4:E9)
future value
REPT
mathematical
In a PMT function, the argument indicated by FV refers to ___.
=SUM(D5:D17)
NOW()
Search for a function
=B3+B4
=AVERAGE(E4:E9)
future value
REPT
mathematical
Sam needs to find the average of a range of numbers. What would be an example of a formula written correctly?
=SUM(D5:D17)
NOW()
Search for a function
=B3+B4
=AVERAGE(E4:E9)
future value
REPT
mathematical
Sam needs to round some figures in a worksheet. The Round funtion is considered to be a ___function.
=SUM(D5:D17)
NOW()
Search for a function
=B3+B4
=AVERAGE(E4:E9)
future value
REPT
mathematical
The SUM function that adds the numbers in the range D5:D17 is ___.
=SUM(D5:D17)
NOW()
Search for a function
=B3+B4
=AVERAGE(E4:E9)
future value
REPT
mathematical
The ___ function returns the current date and time based on the computer's date and times settings
=SUM(D5:D17)
NOW()
Search for a function
=B3+B4
=AVERAGE(E4:E9)
future value
REPT
mathematical
If you were using relative cell references, the formula =A3+A4 would changed to ___ when copied from cell A5 to cell B5.
=SUM(D5:D17)
NOW()
Search for a function
=B3+B4
=AVERAGE(E4:E9)
future value
REPT
mathematical
Check it!