Question: Sample: B C D E F G You want to develop, using Excel, a log for security guards to track entries into the secured area

Sample: B C D E F G You want to develop, using
Sample: B C D E F G You want to develop, using Excel, a log for security guards to track entries into the secured area of a laboratory and record any incidences. We expect there to be 2-20 entries each weekday and 1-4 entries Lab Tracking each weekend for the rest of the year. You will need the following information recorded: date, time, Current Date Current Time Total Test Tubes name of the opening the door, the authorized person entering the lab (with the employee badge 5 3/7/2023 3:47 PM 132 number automatically filling in, these are listed on the next page for you to copy for looking up), the 6 number of test tubes brought in, and space for noting any incidences. This information will have data 7 Date Time Guard Employee Badge # # of Test Tubes Incidence validation with the date restricted to only between 4/1/23 and 12/31/23 and a time only between 7am 8 3/1/2023 7:01 AM Rahu Jessic 1001 4 9 3/1/2023 7:04 AM Scott Matthew 1010 and 7pm. If the date or time is entered outside the allowed boundaries, have an appropriate error alert 10 3/1/2023 7:38 AM David avid 1017 10 Spilled test tube # 3. with good guidance for the user of the log. If you are able to do so, force it so that dates and times in the 11 3/1/2023 6:45 PM Rahul Matthew 1010 12 3/2/2023 8:00 AM Scott Yosef 1020 9 Accidentally drank chemical from test tube # 1 future may not be entered (this is a little trickier, so don't stress if you cannot do this part). The 13 3/2/2023 8:43 AM Rahul Jessica 1001 10 employee names will be chosen from a drop-down menu referencing the appropriate listings below. The 14 3/2/2023 9:13 AM Rahu Mateo 1005 15 3/3/2023 9:45 AM Ashley Stole test tube # 90 number of test tubes must be a whole number between 0 and 10. Near the top of the log, have a Rahul 1009 16 3/3/2023 11:00 AM David Joshua 1011 7 running total of the number of test tubes taken into the laboratory (assume it starts at 0). This should be a formula reaching into the appropriate cells and should be protected so no one accidently overwrites Authorized access listing the formula. There should also be cells near the top showing the current date and time. There is no need (updated 3/1/23) for any data validation for the incidents. Freeze the column labels so they remain visible, even if one employee badge scrolls about. Guard listing Jessica 1001 Sam Mateo 1005 Taylor F. Ashley 1009 Lisa Matthew 1010 Rahul Joshua 1011 Kevin David 1017 Scott Yosef 1020 Taylor C. Sarah 1022 David Jacob 1023 Juan Arnav 1040 John D. 1062 Pari 1065 John K. 1089 Sara 1102 Francisco 1118 Antonia 1122 Benjamin 1127

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!