New Perspectives Excel 365/2021 | Module 1: End of Module Project 1 Natal Biotech GETTING STARTED WITH EXCEL GETTING STARTED 1. 2. O 3. 4. O PROJECT STEPS As the

operations manager, you use Excel to maintain project data and schedule facilities usage. You are finalizing the Projects and Scheduling worksheets for the current week. 5. Save the file NP_EX365_2021_EOM1-1_FirstLastName_1.xlsx as NP_EX365_2021_EOM1-1_FirstLastName_2.xlsx Edit the file name by changing "1" to "2". If you do not see the .xlsx file extension, do not type it. The file extension will be added for you automatically. Begin on the Projects worksheet by increasing the font size of the range A2:A3 to 12 point. Enter the values shown in Table 1 into the corresponding cells in the range B8:C11. Table 1: Data for the Range B8:C11 With the file NP_EX365_2021_EOM1-1_FirstLastName_2.xlsx open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet. If cell B6 does not display your name, delete the file and download a new copy. 8 9 1 0 1 1 B Yvonne Byrom Fiona Hernandez Taisha Zygmont Jared Sandor Adjust the width of Column B using AutoFit. In cell E6, enter the following: AFS51EZ24 C 202 1 202 3 202 4 202 4 Select the range E6:E11, 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 Fill button to properly receive credit for this step.) Hide Column C. CENGAGE New Perspectives Excel 365/2021 | Module 1: End of Module Project 1 6. 7. 8. 9. 10. 11. Switch to the Scheduling worksheet. In cell A3, change the cell content to Week of February 22, 2024 (instead of Week of February 15, 2024). Cut the contents and formatting of the range D15:E18 and paste them into the range A13: B16. In cell B13, create a formula using the COUNT function to determine the number of projects that have booked facility hours by counting the values in the range C6:C11. Adjust the zoom level of the Scheduling worksheet to 120%. Change the page orientation of the Scheduling worksheet to Portrait. Some weeks you need to track facilities-related information, but that's not necessary this week. Move the Facilities worksheet between the Projects and Scheduling worksheets, then hide the Facilities worksheet. 12. When you hand off your worksheet to the facilities team, another colleague will add information about contractors working on site. To create a placeholder worksheet for this data, insert a new worksheet in the workbook, rename the worksheet Contractors, and if necessary, move the new worksheet after the Scheduling worksheet. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workboo and then exit Excel. Follow the directions on the website to submit your completed project. CENGAGE New Perspectives Excel 365/2021 | Module 1: End of Module Project 1 Final Figure 1: Projects Worksheet Microsoft product screenshot reprinted with permission from Microsoft Incorporated. Copyright © 2020 Cengage Learning. All Rights Reserved. A Natal Biotech 1 2 Current Projects 3 Week of February 15, 2024 4 5 Project Title 6 Algae Fuel Synthesis 51 7 Biomarkers 264 8 Immune Therapy 33 9 Protein Folding 5852 10 Water Reclamation 402 11 Gene Splicing 288 12 13 B Project Lead Ernestine Zellers Hester Alvarado Yvonne Byrom Fiona Hernandez Taisha Zygmont Jared Sandor Documentation Projects Scheduling Final Figure 2: Scheduling Worksheet D Branch White Red Red Informatics Blue Red Contrac... (+) ⠀ CENGAGE E Project Code AFS51EZ24 B264HA23 IT33YB21 PF5852FH23 WR402TZ24 GS288JS24 F A New Perspectives Excel 365/2021 | Module 1: End of Module Project 1 A 1 Natal Biotech 2 Project Schedule 3 Week of February 22, 2024 4 5 Project Code 6 AFS51EZ24 7 B264HA23 8 IT33YB21 9 PF5852FH23 10 WR402TZ24 11 GS288JS24 12 13 Total projects for week 14 Median hours per project 15 Greatest project hours 16 Fewest project hours 17 18 ◄ | Projects Scheduling Contractc ... B Resource Lab 2 Lab 1 Computing 2 Computing 1 Lab 1 Lab 2 ◄ CENGAGE 6 42 168 13 с Hours 48 24 168 13 96 36 D