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