Hello, I need help with my homework for my Excel class. I just need more clarification on it. I am on the bottom of question 8. Thanks

AutoSave . Off NP_EX365_2021_1b_HunterBaldwin_1 Search Hunter Baldwin HB Share File Home Insert Page Layout Formulas Data Review View Help Comments Default Ruler Formula Bar Split CD View Side by Side New Arrange Freeze Hide IDI Synchronous Scrolling Normal Page Break Page Custom Zoom 100% Zoom to Switch Macros H Keep Exit New Options Navigation Gridlines Headings Preview Layout Views Selection Window All Panes |Unhide Reset Window Position |Windows Sheet View Workbook Views Show Zoom Window Macros i PRODUCT NOTICE Excel hasn't been activated. To keep using Excel without interruption, activate before Saturday, September 9, 2023. Activate X K10 X C D E F G H K L M N P B - City of New Monroe Committees - May 5, 2024 UI AWN Committee Name Contact Grants Budget Email Address Meets 6 Administration Hannah Brickman $200,000 $300,000 hannah. brickmn@city.org Monthly Economic Development Jeff Kasten $250,000 $350,000 jeff.brickmn@city.org Quarterly 8 Finance Rachel Andreas $124,500 $200,000 rachel.brickmn@city.org Monthly 9 Health & Environment Simon Miro $75,850 $100,000 simon.brickmn@city.org Biweekly 10 Lodging Advisory Claudia Padilla $50,000 $55,000 claudia.brickmn@city.org Quarterly 11 Parking Advisory Angela Robertson $10,900 $12,500 angela.brickmn@city.org Quarterly 12 Planning Jonathon Han $115,500 $175,750 jonathon.brickmn@city.org Monthly 13 Police Advisory Sergio Gomez $95,000 $125,000 sergio. brickmn@city.org Quarterly 14 Technology Jennifer Flynn $210, 750 $285,500 jennifer.brickmn@city.org Monthly 15 $1, 132,500 16 17 18 $125,833.33 19 20 21 22 23 24 25 26 27 Documentation Committees Cash Flow + Ready AccePROJ ECI STEPS 1. As a member of the Finance Committee for the City of New Monroe, you use Excel to maintain city data and summarize cash flow. Go to the Committees worksheet. Cut the contents of the range C2:C3 and paste them into the range BZ:B3. Adjust the width of column B using AutoFit. Change the width of column F to 26.00. Enter the values shown in Table 1 into the corresponding cells in the range BS:E8. Table 1: Data for the Range BB:E8 B C D E 8 Finance Rachel Andreas 124,500 200,000 Enter hannah.brickman@city.org in cell F6. Select the range F6:F14, and then use the Flash Fill button (in the Editing group on the Home tab) to automatically enter codes into the remaining cells in the range. (Hint: You must use the Flash Fi|| button to properly receive credit for this step.) Adjust the width of column G using AutoFit. In cell C15, enter Totals to identify the values you will calculate in the range D15:E15. In cell D15, 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 D6:D14. Copy the formula you created in cell D15 to cell E15 to determine the total budget amounts. [Mac Hint: The user may need to increase the column width to preview the result] In cell B17, enter Number of Committees to identify the value you will calculate in cell C17. New Perspectives Excel 365/2021 | Module l:SAM Project lb 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. In cell C17, create a formula using the COUNT function to determine the number of committees by counting the values in the range D6:D14. In cell B18, enter Average Grant to identify the value in cell C18. Switch to the Cash Flow worksheet. Change the orientation of the Cash Flow worksheet to Landscape. In cell BZ, change the cell content to City of New Monroe (instead ofjust reading "City of\"). Select the range B5:BQ and the nonadjacent cell C5, and then increase the font size of the cells to 12 point. To better display the column headings, manually change the height of row 6 to 36.00. (Hint: Do not use AutoFit.) 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 C9 to the range D9:F9. Select the range G7:G9, and then apply AutoSum to calculate the total receipts, disbursements, and change in cash for weeks 1 through 4. Clear the contents of cell 311 because you edited the worksheet after February 1, 2024. Apply the Wrap Text formatting to cell G6. Adjust the Zoom level of the Cash Flow worksheet to 110% to make the contents easier to read. 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. 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 project