How do I enter the formula?

c. Update the text in cell D6 to: Quarter expenses 4. The worksheet is missing formulas to calculate totals. Enter formulas using the SUM function to calculate the following totals. Use any of the methods you learned in this chapter. a. Enter a formula in cell B7 to calculate the total monthly income. b. Enter a formula in cell B24 to calculate the total monthly expenses. c. Enter a formula in cell E16 to calculate the total quarter expenses. d. Use the status bar to verify that the formula is calculating the correct total for each cell range. Cell E18 displays the number of months in the quarter. Change the number format in this cell to the Number format with no numbers showing after the decimal (so the number appears as 3 instead of $3.00 ). The number format in the Quarter Expenses section does not match the number format in the other sections of the worksheet. Change the number format for cells E11:E16 to the Accounting Number Format. 7. Review the formulas in the Discretionary Income section. a. Cells E4:E6 should contain references to the cells where you just entered the formulas to calculate totals. Add the appropriate formula to cell E6 to reference the value in cell E16 (the total quarter expenses). b. The quarter is three months long, so the formulas in cells E4 and E5 should multiply the total monthly income and total monthly expenses by three. Correct the formulas in cells E4 and E5. Use an absolute reference to the value in cell E18 (the number of months in the quarter). College Budget c. Update the text in cell D6 to: Quarter expenses 4. The worksheet is missing formulas to calculate totals. Enter formulas using the SUM function to calculate the following totals. Use any of the methods you learned in this chapter. a. Enter a formula in cell B7 to calculate the total monthly income. b. Enter a formula in cell B24 to calculate the total monthly expenses. c. Enter a formula in cell E16 to calculate the total quarter expenses. d. Use the status bar to verify that the formula is calculating the correct total for each cell range. Cell E18 displays the number of months in the quarter. Change the number format in this cell to the Number format with no numbers showing after the decimal (so the number appears as 3 instead of $3.00 ). The number format in the Quarter Expenses section does not match the number format in the other sections of the worksheet. Change the number format for cells E11:E16 to the Accounting Number Format. 7. Review the formulas in the Discretionary Income section. a. Cells E4:E6 should contain references to the cells where you just entered the formulas to calculate totals. Add the appropriate formula to cell E6 to reference the value in cell E16 (the total quarter expenses). b. The quarter is three months long, so the formulas in cells E4 and E5 should multiply the total monthly income and total monthly expenses by three. Correct the formulas in cells E4 and E5. Use an absolute reference to the value in cell E18 (the number of months in the quarter). College Budget