Description

Pts

Your Score

Documentation sheet with your name, the date, and the purpose of the workbook inserted at the beginning of the workbook

5

Formulas in the ranges C7:N7 and C20:N20 to calculate the total income and expenses for each month.

5

In range C22:N22, enter a formula to calculate Ashlee’s net income.

5

In the range D23:N23, enter a formula using the SUM function to calculate the running total for net income from February to December.

5

In the range C5:N5, use Auto Fill to fill in the month names Jan-06, Feb-06, Mar-06

2

In cell O5, enter the column heading Total. In the range O6:O22, enter a formula to calculate the total income and expenses for the year, using SUM function

8

In the range C27:E43, enter formulas to calculate the average values for income, expenses, and net income using the AVERAGE function.

8

In the range C27:E43, enter formulas to calculate the minimum values for income, expenses, and net income using the MIN function.

8

In the range C27:E43, enter formulas to calculate the maximum values for income, expenses, and net income using the MAX function.

8

Rename the last worksheet Loan Analysis. Enter the text Loan Analysis in cell A1

2

In the range C3:C4, enter cell references to the values in C27:C28 of the Budget worksheet, in order to reference Ashlee’s Average income

8

In the range C7:C16, enter cell references to the values in C31:C40 of the Budget worksheet, in order to reference Ashlee’s Average expenses.

8

In the cell C19, calculate the net income.

8

Loan Payment conditions area labels and formulas

5

PMT function correct

5

Loan Analysis area  labels and formulas

5

IF function correct

5

TOTAL POSSIBLE POINTS:

100