Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
If you were using relative cell references, the formula =A3+A4 would changed to ___ when copied from cell A5 to cell B5.
NOW()
=SUM(D5:D17)
mathematical
future value
=AVERAGE(E4:E9)
Search for a function
Editing
=B3+B4
Sam needs to find the average of a range of numbers. What would be an example of a formula written correctly?
NOW()
=SUM(D5:D17)
mathematical
future value
=AVERAGE(E4:E9)
Search for a function
Editing
=B3+B4
The Sum button is located in the __group on the Home tab of the Ribbon.
NOW()
=SUM(D5:D17)
mathematical
future value
=AVERAGE(E4:E9)
Search for a function
Editing
=B3+B4
The SUM function that adds the numbers in the range D5:D17 is ___.
NOW()
=SUM(D5:D17)
mathematical
future value
=AVERAGE(E4:E9)
Search for a function
Editing
=B3+B4
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.
NOW()
=SUM(D5:D17)
mathematical
future value
=AVERAGE(E4:E9)
Search for a function
Editing
=B3+B4
Sam needs to round some figures in a worksheet. The Round funtion is considered to be a ___function.
NOW()
=SUM(D5:D17)
mathematical
future value
=AVERAGE(E4:E9)
Search for a function
Editing
=B3+B4
In a PMT function, the argument indicated by FV refers to ___.
NOW()
=SUM(D5:D17)
mathematical
future value
=AVERAGE(E4:E9)
Search for a function
Editing
=B3+B4
The ___ function returns the current date and time based on the computer's date and times settings
NOW()
=SUM(D5:D17)
mathematical
future value
=AVERAGE(E4:E9)
Search for a function
Editing
=B3+B4
Check it!