Excel Project 5 A: Question Preview (ID: 339)

Below is a preview of the questions contained within the game titled EXCEL PROJECT 5 A: Working With Functions .To play games using this data set, follow the directions below. Good luck and have fun. Enjoy! [print these questions]

Play games to reveal the correct answers. Click here to play a game and get the answers.

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
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 the data set above, visit ReviewGameZone.com and enter game ID number: 339 in the upper right hand corner at ReviewGameZone.com or simply click on the link above this text.

Log In
| Sign Up / Register