advance analysis the spreadsheet

User Generated

ohtf1012

Business Finance

Description

Please help I need to edit a excel document attached based on the instructions from the screen shot attached. The problem I have is that I am not sure what to do.


Thanks

Unformatted Attachment Preview

Unique Physique Service and Sales Months January January January February February February March March March April April April May May May June June June Total Average Maximum Minimum #of Clients 245 189 234 156 234 345 252 167 298 258 345 234 278 267 315 214 287 321 4639 258 345 156 Service Personal Training Yoga Detary Consulation Personal Training Yoga Detary Consulation Personal Training Yoga Detary Consulation Personal Training Yoga Detary Consulation Personal Training Yoga Detary Consulation Personal Training Yoga Detary Consulation Sales $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 150,000 134,367 145,234 215,908 214,607 123,564 233,675 367,890 245,107 135,612 214,576 256,234 324,592 232,345 267,806 189,234 320,100 234,120 4,004,971 222,498 367,890 123,564 Service Sales - Х TCH017_Final_Project_Part_II.pdf - Adobe Acrobat Reader DC File Edit View Window Help Home Tools dma-9006 Carolin... 3335 resdi page.pdf dma-5097-ia.pdf dss-8227.pdf ncfast-20009.pdf X dma-5046 Transp... dma-5003-ia FC ap... TCHO17_Final_Proje... X ? Sign In ncfast-20009.pdf / 3 172% 1 Technology | Graded Assignment Final Project, Part II 4 Export PDF Create PDF LA Section 2: Apply Advanced Analysis to the Spreadsheet Adobe PDF Pack Problem: After looking at the spreadsheet you created, Tonya would like you to conduct advanced analysis on it. She wants to use this data to analyze her business efforts. Convert files to PDF and easily combine them with other file types with a paid subscription Select File to Convert to PDF Instructions, Part 1: Open the spreadsheet you created titled Service_Sales_Your_Name. Using Tonya's notes below, prepare the spreadsheet. Select File . Edit PDF Comment Combine Files - Organize Pages . Cu Fill & Sign In cell F4, enter the label Service. In cell F5, use the Filter feature to find each type of service Tonya offers in the Service column. In cell G4, enter the label # of Sales. In cell G5, use the COUNTIF function to find out how many times each service was entered. Use the Service column as the range and the services in Column F as the criteria. Modify the formula in cell G5 to include absolute references. Copy the formula in cell G5 for the remaining services. In cell H4, enter the label Total Sales. In cell H5, use the SUMIF function to calculate the total sales for each service. Use the Service column as the range, the services in Column F as the criteria, and the Sales column as the range for the sum. Create a column chart that shows the # of Sales and Total Sales for each service. Include a title and legend. Name the Y axis Total Sales, and the X axis Services. Insert the bar chart in the spreadsheet beginning in cell J5. Resize the chart if needed to make it fit on the spreadsheet neatly. xile Send for Signature . →... Send & Track # More Tools 07 are files in the int Cloud Instructions, Part 2: Save the file as Service_Sales_2_Your_Name. More Q Type here to search 0 L ge Ad 11:34 AM 5/18/2018 1
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Here you go. Please let me know if you need any changes.

Unique Physique
Service and Sales
Months
January
January
January
February
February
February
March
March
March
April
April
April
May
May
May
June
June
June
Total
Average
Maximum
...


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags