Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
______________ functions test for more than one condition by including additional IF formulas.
AVERAGE
COUNTBLANK
False
NESTED IF
without
True
False
FV
Nested IF functions test for more than one condition by including additional IF formulas.
AVERAGE
COUNTBLANK
False
NESTED IF
without
True
False
FV
The function to count all cells in the specified range that are blank is
AVERAGE
COUNTBLANK
False
NESTED IF
without
True
False
FV
If you do not want the date to update each time you open a workbook, just type the date ______________ using a function.
AVERAGE
COUNTBLANK
False
NESTED IF
without
True
False
FV
Variable data are not amounts that are subject to change.
AVERAGE
COUNTBLANK
False
NESTED IF
without
True
False
FV
The IF function requires that you specify three arguments in order: the value if true, the logical test, and the value if false.
AVERAGE
COUNTBLANK
False
NESTED IF
without
True
False
FV
The function calculates the future value of an investment based on fixed payments earning a fixed rate of interest across equal time periods.
AVERAGE
COUNTBLANK
False
NESTED IF
without
True
False
FV
To calculate the average of specified values use the _______________ function.
AVERAGE
COUNTBLANK
False
NESTED IF
without
True
False
FV
Check it!