NewPerspectives Excel$365/2021|$ Module $1$:SAMProject la

$9.$ Enter Number of Employees in cell A$19.$

$10.$ In cell $B19,$ create a formula using the couwi function to determine the number of people employed by Tabula Insurance Agency by counting the values in the range B$58316.$

$11.$ Enter the text Average Commission in A$21.$

$12.$ Switch to the Cash Flow worksheet. Change the orientatton of the Cash Flow worksheet to Landseape.

$13.$ In cell $A{2}_2,$ change the cell content to Gash Flow: Aprill $4-10,2024($instead of Just reading "April $4-10,2024\%).$

$14.$ Select the range $A4$:$E4$ and the nonadjacent cell $G8,$ and then Increase the font size of the cells to $22$ point.

$15.$ To better display the content, manually change the height of row $3$ to $8\mathrm{.}00.($Clints Do not use Autofit.$)$

$16.$ In cell B$7,$ enter a formula without using a function to determine the profit generated from auto insurance policies by subtracting auto expenses $($cell B$6)$ from auto sales $($cell B$5)$ for the week of April $4-10,2024.$ Copy the formula you created in cell B$7$ to the range C$7$:D$7.$

$17.$ Atter determining the total profits generated by each store, you are now interested in calculating the total sales, expenses, and profits across all types of insurance sold. Select the range E$5$: F$7,$ and then apply AutoSum to calculate the totals for these categories across all three types of insurance.

$13.$ Since you fust edited the worksheet, the content in cell A$9$ is no longer aceurate. Click on cell $A9$ and clear its contents.

$19.$ Apply the Urap Text formatting to cell $63.$

$20.$ Adjust the Zoom level of the Cash Flow worksheet to $130\%.$

$21.$ After reviewing the Personnel and Cash Flow worksheets, you typically generate some additional data for accounting. To create a placeholder worksheet for this data, insert a new worksheet in the workbook, rename the workheet Accounting, and If necessary, move the new worksheet after the Cash Flow worksheet.

Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the website to submit your completed prejeck.