Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions