Excel Project 5 A Question Preview (ID: 339)

Working With Functions. TEACHERS: click here for quick copy question ID numbers.

If you entered =IF(D9/E9,D9,
a) D9
b) D9/E9
c) Empty
d) E9

The function = MAX(E3:E15) in cell C17 will display
a) largest value in the cells between E3 and E15
b) first value in the range
c) last value in the range
d) largest value in the cells between and including E3 and E15

Using the FV function, Excel refers to the fixed payment at equal intervals as a(n)
a) lump sum
b) annuity
c) loan payment
d) fixed payment

If you entered =IF(D9<D10,D9,0) in cell D12, what would display if D9=12 and D10=4 ?
a) 0
b) 16
c) 4
d) 12

Which of the following arguments must be expressed as a negative to create a postive payment amount in the PMT function?
a) Rate
b) FV
c) PV
d) Nper

What does Nper stand for?
a) Number of periods
b) No percent
c) Number percent
d) Number of persons

The If function would NOT be used to determine
a) payment for a loan if you borrowed a specific amount
b) if goals were met
c) employee bonus
d) student\'s grades

How many IF functions can be nested in one IF statement?
a) 7
b) None
c) 13
d) 5

The FV function calculates the future value of an investment based on fixed payments earning a variable rate of interest across equal time periods.
a) True
b) False
c) Sometimes

You would use one of the COUNT functions to sum selected cells within a specific range.
a) True
b) False
c) Sometimes

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 339 in the upper right hand corner or click here.

Log In
| Sign Up / Register