Excel Project 5 B: Question Preview (ID: 356)


Below is a preview of the questions contained within the game titled EXCEL PROJECT 5 B: 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.

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

TEACHERS / EDUCATORS
Log In
| Sign Up / Register