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.
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
Log In | Sign Up / Register