YO16_XL_CH07_GRADER_PC_HW – Spa Part C 1.2

Can you help me understand this Excel question?

Please do the excel in the excel sheets I gave you. The grading system can detect cheating behavior

Annaliese Owen

Project Description:

The Turquoise Oasis Spa serves resort guests with a full range of services from traditional and alternative massage to aromatherapy and detoxification therapy. The spa is open seven days a week. Meda Rodate, the spa manager, would like a workbook that allows her to summarize and compare the sales of each therapist and services used for each day the spa is open.

Steps to Perform:

Step

Instructions

Points Possible

1

Open the downloaded e04ch07_grader_pc_SpaPrices.xlsx workbook.
Save the file as e04ch07_grader_pc_SpaPrices_LastFirst, using your last and first name.

0

2

Customize Quick Access Toolbar to include the Compare and Merge Workbooks command.
Share thee04ch07_grader_pc_SpaPrices_LastFirst workbook; allow changes by more than one user at the same time.
Save the shared workbook as e04ch07SpaRodate_LastFirst, using your last and first name. Leave the workbook open.
Open the e04ch07_grader_pc_SpaPrices_LastFirst.xlsx workbook. Save the workbook as e04ch07_grader_pc_SpaKia_LastFirst using your last and first name.
In the e04ch07_grader_pc_SpaKia_LastFirst workbook, make the following changes in the Price column for the listed products.
Cell C2: Product=Facial – Mud & Citrus; New Price=100
Cell C7: Product=Makeup Consultation; New Price=100
Cell C8: Product=Manicure & Pedicure Package; New Price =70
Cell C9: Product=Manicure & Polish; New Price=45
Cell C10: Product=Pedicure & Polish; New Price=45
Cell C11: Product=Waxing – Body; New Price=75
Save and close the e04ch07_grader_pc_SpaKia_LastFirst workbook.

1

3

In the e04ch07SpaRodate_LastFirst workbook, make the following changes in the Price column for the listed products.

Cell C17: Product=Massage – Deep Tissue; New Price=125
Cell C18: Product=Massage – Deep Tissue; New Price=112.50
Cell C19: Product=Massage – Fusion; New Price=150
Cell C20: Product=Massage – Fusion; New Price=137.50
Cell C21: Product=Massage – Shiatsu; New Price=150
Cell C25: Product=Steam Bath; New Price=75
Cell C26: Product=Tibetan Reiki Therapy; New Price=225

Click Save and close to close the workbook but keep Excel open.

0

4

Open the e04ch07_grader_pc_SpaPrices_LastFirst workbook. The title bar of the window should display [Shared] after the file name.
Compare and Merge the SpaPrices workbook with the SpaKia workbook.
Compare and Merge the SpaPrices workbook with the SpaRodate workbook.

5.4

5

Save the changes history on the SpaPrices workbook. Save the changes made by All and list the changes on a new sheet.
Copy all contents of the History sheet.
Create a new sheet named Changes. Paste the contents from the History worksheet.

3.6

6

Save the workbook, exit Excel, and then submit the e04ch07_grader_pc_SpaPrices_LastFirst.xlsx file according to your instructor’s directions.

0