Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
The FV function calculates the future value of an investment based on fixed payments earning a variable rate of interest across equal time periods.
False
7
Number of periods
fixed payment
first value in the range
payment for a loan if you borrowed a specific amount
False
Empty
You would use one of the COUNT functions to sum selected cells within a specific range.
False
7
Number of periods
fixed payment
first value in the range
payment for a loan if you borrowed a specific amount
False
Empty
What does Nper stand for?
False
7
Number of periods
fixed payment
first value in the range
payment for a loan if you borrowed a specific amount
False
Empty
If you entered =IF(D9/E9,D9,
False
7
Number of periods
fixed payment
first value in the range
payment for a loan if you borrowed a specific amount
False
Empty
How many IF functions can be nested in one IF statement?
False
7
Number of periods
fixed payment
first value in the range
payment for a loan if you borrowed a specific amount
False
Empty
Using the FV function, Excel refers to the fixed payment at equal intervals as a(n)
False
7
Number of periods
fixed payment
first value in the range
payment for a loan if you borrowed a specific amount
False
Empty
The function = MAX(E3:E15) in cell C17 will display
False
7
Number of periods
fixed payment
first value in the range
payment for a loan if you borrowed a specific amount
False
Empty
The If function would NOT be used to determine
False
7
Number of periods
fixed payment
first value in the range
payment for a loan if you borrowed a specific amount
False
Empty
Check it!