Please help me.. (I attached excel sheets below the intructions) The Turquoise Oasis Spa serves resort guests
Question:
Please help me.. (I attached excel sheets below the intructions)
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.
Step
Instructions
1
Open the downloaded file, e04ch07_grader_Spa.xlsx. Save the file as e04ch07_grader_Spa_LastFirst using your last and first name.
2
Group the IstasChristy, LaultKendra, and NieseJason worksheets. Change the tab color to Dark Blue, Text 2, Lighter 60%.
3
With the worksheets still grouped, in cell A25, type Total.
4
With the worksheets still grouped, in cell E7, type =C7*D7. Copy the formula through cell range E7:E24.
In F7, type =E7.
In F8, type =F7+E8. Copy the formula through cell range F8:F24.
Ungroup the worksheets.
5
On the IstasChristy worksheet, in cells C25:E25, use the SUM function to total the cell range C7:E24.
Group the sheets to copy the contents across worksheets to the MaultKendra and NieseJason worksheets.
6
If necessary, group the IstasChristy through NieseJason worksheets. For cell range A6:F6, apply the Accent 5 cell style.
For cell range C25:E25, apply the Total cell style.
Ungroup the worksheets.
7
On the IstasChristy worksheet, in cells E7:F24, fill the formats across the MaultKendra and NieseJason worksheets.
8
Delete the dates in cell A4 on the MaultKendra and NieseJason worksheets. Change the dates so the MaultKendra and NieseJason worksheets have a 3-D reference to cell A4 of the IstasChristy worksheet.
9
CreateA 3-D name for cell E25 on the IstasChristy:NieseJason worksheets. Name the range TotalCharges3D
10
On the HoursSummary worksheet, in cell B7, createAa 3-D formula that totals cell C7 of the IstasChristy through NieseJason worksheets. Copy the formula through cell B24.
On the HoursSummary worksheet, in cell C7, createAa 3-D formula that totals cell E7 of the IstasChristy through NieseJason worksheets. Copy the formula through cell C24.
11
On the ChargesSummary worksheet, in cell B7, consolidate data using the SUM function for the data in cell E7:F24 of the IstasChristy, MaultKendra, and NieseJason worksheets.
12
On the ServiceSummary worksheet, in cell A6, consolidate data for cells B6:E24 on the IstasChristy, MaultKendra, and NieseJason worksheets added (in thatorder). Use the top row and left column as labels.
In cell A6, type Service
Autofit the column width of columns A:D.
In cell D20, type =SUM(TotalCharges3D)
13
On the ChargesSummaryLinked worksheet, in cell A6, consolidate data for cells A6:F24 on the IstasChristy, MaultKendra, and NieseJason worksheets (n that order) using top row and left column as labels and create links to source data.
AutoFit Column Width of columns A:G.
Format A10:A78 with the Time, 1:30 PM format.
14
Save the file, exit Excel, and submit the e04ch07_grader_pc_Spa_LastFirst workbook.
https://drive.google.com/file/d/1RiDJw1jmSSIdY57L_1KkW57s5e6z7CcW/view