4. in the range C20:N20, calculate the family's take home pay. in the range C26:N26, calculate the monthly expenses. in the range C27:N27, Calculate the monthly net flow (equals to the monthly take home pay minus the expenses)

5. in cell c6, enter a formula to calculate the sum of glenn's monthly salary for the entire year. in cell d6, calculate glenn's average take home pay each month. in cell e6, calculate glenn's maximum monthly take home pay. in cell f6, calculate glenn's minimum monthly take home pay.

6. select range c6:f6, and then use autofill to copy the formula in the c6:f6 range into the c7:f15, use the autofill options to copy only the formula into the selected range and not both the formula and formats. (HINTS: Because you haven't yet entered any mortgage payment values, cell D13 will show the value as #DIV/0!; indicating that excel cannot calculate the average mortgage payment. you'll correct that problem shortly.)