Excel Project 5 B Question Preview (ID: 356)


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

Nested IF functions test for more than one condition by including additional IF formulas.
a) True
b) False
c) Sometimes
d)

The function calculates the future value of an investment based on fixed payments earning a fixed rate of interest across equal time periods.
a) PV
b) FV
c) PMT
d) IF

To calculate the average of specified values use the _______________ function.
a) AVE
b) SUM
c) AVERAGE
d) PMT

______________ functions test for more than one condition by including additional IF formulas.
a) IF/THEN
b) NESTED IF
c) NOW
d) MEDIAN

If the IF function calculates a bonus if true and zero if false, the zero would be the second argument.
a) True
b) False
c) Sometimes
d)

If you do not want the date to update each time you open a workbook, just type the date ______________ using a function.
a) by
b) without
c) sometimes
d) by always

The function to count all cells in the specified range that are blank is
a) COUNTBLANK
b) MEDIAN
c) COUNTA
d) MODE

Variable data are not amounts that are subject to change.
a) True
b) False
c)
d)

The IF function requires that you specify three arguments in order: the value if true, the logical test, and the value if false.
a) True
b) False
c)
d)

When entering the NOW function, =NOW( ) will produce
a) just the current date
b) just the current time
c) #NAME?
d) the current date and time

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: 356 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links