Excel Project 5 B

Test Description: Working With Functions

Instructions: Answer all questions to get your test result.

1) Nested IF functions test for more than one condition by including additional IF formulas.

2) The function calculates the future value of an investment based on fixed payments earning a fixed rate of interest across equal time periods.

3) To calculate the average of specified values use the _______________ function.

4) ______________ functions test for more than one condition by including additional IF formulas.

5) If the IF function calculates a bonus if true and zero if false, the zero would be the second argument.

6) If you do not want the date to update each time you open a workbook, just type the date ______________ using a function.

7) The function to count all cells in the specified range that are blank is

8) Variable data are not amounts that are subject to change.

9) The IF function requires that you specify three arguments in order: the value if true, the logical test, and the value if false.

10) When entering the NOW function, =NOW( ) will produce


*select an answer for all questions

Play Games with the Questions Above


Teachers: Create FREE classroom games with your questions Click for more info!
©2007-2023 ReviewGameZone.com | About | Privacy | Contact | Terms | Site Map