YO16_XL_CH07_GRADER_PC_HW – Spa Part C 1.2

Get perfect grades by consistently using www.assignmentgeeks.org. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

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

"Is this question part of your assignment? We can help"

ORDER NOW
Writerbay.net

Need help with an assignment? We work for the best interests of our clients. We maintain professionalism and offer brilliant writing services in most of the fields ranging from nursing, philosophy, psychology, biology, finance, accounting, criminal justice, mathematics, computer science, among others. We offer CONFIDENTIAL, ORIGINAL (Turnitin & SafeAssign checks), and PRIVATE services using the latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and doctorate-prepared writers. Thank you in advance!

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper