Project 3B. Lab Supervisors
In Activities 3.5 through 3.10, you will edit a workbook created by Ram Singh, assistant director of the Information Technology Center at Lake Michigan City College. The workbook checks a monthly schedule to confirm that it meets a management guideline that indicates a computer lab supervisor cannot average more than eight hours a day in a month. Your completed worksheet will look similar to Figure 3.14.
Figure 3.14.
|
For Project 3B, you will need the following file: |
|
e03B_Lab_Supervisors |
You will save your workbook as
3B_Lab_Supervisors_Firstname_Lastname
Objective 3 Use COUNTIF and IF Functions, and Apply Conditional Formatting
|