Question: 10 On the Report worksheet, create calculations that will help hotel employees manage the fitness class enrollments. The user will put an x in range

10 On the Report worksheet, create calculations that will help hotel employees manage the fitness class enrollments. The user will put an x in range E4:E10, indicating which class to report on and an x in range H4:H5 if employees want a report on a specific gender. In cell A4, use a MATCH function nested in an INDEX function to retrieve the Class that was selected in E4:E10. The MATCH should find the row where the x is located and would be used within the INDEX to pull the associated Class value from the same row within range F4:F10. In cell B4, use a MATCH function nested in an INDEX function to retrieve the Gender that was selected in H4:H5, looking at the x in column H and returning the F or M for the Gender criteria. Using a MATCH nested in an INDEX function, retrieve the gender that was selected in H4:H5. Nest the MATCH and INDEX formula inside the IFERROR function in case the user does not select a specific gender. The IFERROR should leave the cell blank if a gender is not selected.

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!