In cell $C15,$ enter Totals to identify the values you will calculate in the range $D15$:$E15.$

In cell D$15,$ create a formula using the SUM function to determine the total amount of grants received by the city by totaling the values in the range D$6$:D$14.$ Copy the formula you created in cell D$15$ to cell E$15$ to determine the total budget amounts. $[$Mac Hint: The user may need to increase the column width to preview the result.$]$

In cell B$17,$ enter Number of Committees to identify the value you will calculate in cell C$17.$

In cell $C17,$ create a formula using the COUNT function to determine the number of committees by counting the values in the range D$6$:D$14.$

New Perspectives Excel $2019|$ Module I: SAM Project $1b$

$11.$ In cell B$18,$ enter Average Grant to identify the value in cell $C18.$

$12.$ Switch to the Cash Flow worksheet. Change the orientation of the Cash Flow worksheet to Landscape.

$13.$ In cell B$2,$ change the cell content to City of New Monroe $($instead of just reading "City of$").$

$14.$ Select the range $B5$:$B9$ and the nonadjacent cell $C5,$ and then increase the font size of the cells to $12$ point.

$15.$ To better display the column headings, manually change the height of row $6$ to $36\mathrm{.}00.($Hint: Do not use AutoFit.$)$

$16.$ In cell $C9,$ enter a formula without using a function to determine the change in cash in week $1$ by subtracting disbursements $($cell $C8)$ from receipts $($cell $C7).$ Copy the formula you created in cell C$9$ to the range D$9$:F$9.$

$17.$ Select the range $G7$:$G9,$ and then apply AutoSum to calculate the total receipts, disbursements, and change in cash for weeks $1$ through $4.$

$18.$ Clear the contents of cell B$11$ because you edited the worksheet after February $1,2021.$

$19.$ Apply the Wrap Text formatting to cell G$6.$

$20.$ Adjust the Zoom level of the Cash Flow worksheet to $110\%$ to make the contents easier to read.

$21.$ You typically submit financial data to the auditor for verification. To create a placeholder worksheet for this data, insert a new worksheet in the workbook, rename the worksheet Auditing, and if necessary, move the new worksheet after the Cash Flow worksheet.