Question: Instructions Start Excel. Open the downloaded Excel file named e04_grader_a2_HotelSchedule.xlsx. Save it as a MacroEnabled workbook named e04_grader_a2_HotelScheduIe_LastFirst, using your last and first name. If

 Instructions Start Excel. Open the downloaded Excel file named e04_grader_a2_HotelSchedule.xlsx. Save

it as a MacroEnabled workbook named e04_grader_a2_HotelScheduIe_LastFirst, using your last and first

Instructions Start Excel. Open the downloaded Excel file named e04_grader_a2_HotelSchedule.xlsx. Save it as a MacroEnabled workbook named e04_grader_a2_HotelScheduIe_LastFirst, using your last and first name. If necessary, click Enable content. and click OK in the message box. On the Schedule worksheet, create a list validation rule in cells A7:A26 with the source data from cells A3:A12 on the Employees worksheet. The Input message should say Choose a name from the list. and the Error message should say Invalid name. (include the periods). In cell A7, select Eric Mosley. In cells C7:I26, create a list validation rule with the source data from cells A3:A9 on the Shifts worksheet. Leave the Input and Error messages blank. In cell C3, create an any value validation rule with an Input message that says Enter the starting date for the week. (include the period). Type =TODAYO in cell A3. Select cell .127. and then correct the formula so there is no longer a circular reference. On the Employees worksheet, delete column B. This will cause a #REF! error on the Schedule worksheet. Open the downloaded eO4_grader_a2_HotelEmployee.xlsx workbook. In the HotelSchedule workbook. click the Schedule worksheet and modify the table array reference in the VLOOKUP formulas in cells 37:326 to reference the named range Employee on the HotelEmployee workbook. Close the O4_grader_a2_HoteIEmployee workbook. On the Schedule worksheet, select cell A6, and then insert a hyperlink to go to the Employees worksheet. Add a ScreenTip, Go to the Employee worksheet (no period). On the Employees worksheet, Points Possible 12 10 14 14 10

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 Finance Questions!