Excel Project 5 B

Match it! Select the correct answer from the pull down...Good luck!

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

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

Variable data are not amounts that are subject to change.

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

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

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

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

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