Description
Use the instructions to fill the Excel file
Unformatted Attachment Preview
Natal Biotech
Current Projects
Week of February 15, 2024
Project Title
Project Lead
Algae Fuel Synthesis 51
Biomarkers 264
Immune Therapy 33
Protein Folding 5852
Water Reclamation 402
Gene Splicing 288
Ernestine Zellers
Hester Alvarado
Project Launch Year
2024
2023
Branch
White
Red
Red
Informatics
Blue
Red
Project Code
Natal Biotech
Project Schedule
Week of February 15, 2024
Project Code
Resource
AFS51EZ24
B264HA23
IT33YB21
PF5852FH23
WR402TZ24
GS288JS24
Lab 2
Lab 1
Computing 2
Computing 1
Lab 1
Lab 2
Hours
48
24
168
13
96
36
Total projects for week
Median hours per project42
Greatest project hours 168
Fewest project hours
13
New Perspectives Excel 365/2021 | Module 1: End of Module Project 1
Natal Biotech
GETTING STARTED WITH EXCEL
PROJECT STEPS
1.
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.
Begin on the Projects worksheet by increasing the font size of the range A2:A3 to 12
point.
2.
Enter the values shown in Table 1 into the corresponding cells in the range B8:C11.
Table 1: Data for the Range B8:C11
8
9
10
11
B
C
Yvonne
Byrom
Fiona
Hernandez
Taisha
Zygmont
Jared Sandor
2021
3.
Adjust the width of Column B using AutoFit.
4.
In cell E6, enter the following:
AFS51EZ24
2023
2024
2024
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.)
5.
Hide Column C.
6.
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).
7.
Cut the contents and formatting of the range D15:E18 and paste them into the range
A13:B16.
8.
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.
9.
Adjust the zoom level of the Scheduling worksheet to 120%.
10.
Change the page orientation of the Scheduling worksheet to Portrait.
11.
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.
New Perspectives Excel 365/2021 | Module 1: End of Module Project 1
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 workbook, and then exit Excel. Follow the directions on the website to submit your
completed project.
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.
New Perspectives Excel 365/2021 | Module 1: End of Module Project 1
Final Figure 2: Scheduling Worksheet
Purchase answer to see full
attachment
