Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
If you entered =IF(D9
fixed payment
PV
Number of periods
payment for a loan if you borrowed a specific amount
False
first value in the range
0
7
Which of the following arguments must be expressed as a negative to create a postive payment amount in the PMT function?
fixed payment
PV
Number of periods
payment for a loan if you borrowed a specific amount
False
first value in the range
0
7
Using the FV function, Excel refers to the fixed payment at equal intervals as a(n)
fixed payment
PV
Number of periods
payment for a loan if you borrowed a specific amount
False
first value in the range
0
7
You would use one of the COUNT functions to sum selected cells within a specific range.
fixed payment
PV
Number of periods
payment for a loan if you borrowed a specific amount
False
first value in the range
0
7
What does Nper stand for?
fixed payment
PV
Number of periods
payment for a loan if you borrowed a specific amount
False
first value in the range
0
7
The If function would NOT be used to determine
fixed payment
PV
Number of periods
payment for a loan if you borrowed a specific amount
False
first value in the range
0
7
The function = MAX(E3:E15) in cell C17 will display
fixed payment
PV
Number of periods
payment for a loan if you borrowed a specific amount
False
first value in the range
0
7
How many IF functions can be nested in one IF statement?
fixed payment
PV
Number of periods
payment for a loan if you borrowed a specific amount
False
first value in the range
0
7
Check it!
Match it!
Match it!