Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Exit through the gift shop worksheet answers

19/11/2021 Client: muhammad11 Deadline: 2 Day

Office 2016 – myitlab:grader – Instructions Excel Project

YO16_XL_CH06_GRADER_PS1_HW - Gift Shop Sales Review 1.8

Project Description: The sales team at the Painted Treasures Gift Shop would like to review its staff’s sales after some of the new staff members have finished a sales training program. You have been given the data for May 2018 and more data will be added in the future. The sales team wants you to review the data, perform some data analyses, and answer some specific questions. This will help the sales team determine how well the staff is performing, and who needs further training.

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Open the downloaded Excel file named e03ch06_grader_h1_ShopSales.xlsx. Save the file with the name e03ch06_grader_h1_ShopSales_LastFirst, using your last and first name. 0 2 Create a copy of the Sales worksheet, and then place it at the end of the workbook. Rename the Sales (2) worksheet as SalesBackup 6 3 On the Sales worksheet, insert a table with headers that uses the range $A$15:$I$212. With the data table selected, create named ranges using the top row as the names. 16 4 Copy range A15:I15, and then paste the range in cell A1. In cell G2, type Receptionist. In cell I2, type Card 4 5 Create an advanced filter using the data in range A1:I2 as the Criteria range and A15:I212 as the List range. Filter the list in-place to display the filtered data on the Sales worksheet. Insert a new sheet, and then rename the new sheet Filter. Copy the filtered data from the table on the Sales worksheet, and then place it in cell A1 on the Filter worksheet. Resize the columns so all the data is visible. 8 6 On the Sales worksheet, in cell J15, type Subtotal. In cell J16, enter a formula using structured references that multiplies Units and Retail_Price. Format the Subtotal column as Accounting Number Format. Create a named range for the Subtotal column that uses the column heading as the name. Note, Mac users, copy the formula down through the column, if necessary. 10 7 Use the SUBTOTAL function to complete the following: In cell H7, insert a formula that counts the number of cells in the Category field that are not empty. In cell H8, insert a formula that sums the cells in the Units field. In cell H9, insert a formula that sums the cells in the Subtotal field. In cell H10, insert a formula that averages the cells in the Retail_Price field. 8 8 On the Sales worksheet, using the range A15:J212, insert a PivotTable in cell A12 on the SalesAnalysis worksheet. 8 9 Configure the PivotTable using the following. Add Units, Staff, and Staff Category to the PivotTable. Move Staff Category to the COLUMNS area. Using the Column Labels arrow, uncheck Manager. Right-click cell E14, point to Sort, and then sort the data in ascending order. 4 10 View the data in the PivotTable to determine the employee with the highest number of units sold. In cell A2, click the drop-down arrow, and then select the name of the employee with the highest number of units sold. In cell A3, click the drop-down arrow, and then select the name of the employee with the second highest number of units sold. 4 11 View the PivotTable data to determine the employee with the lowest number of units sold. Click cell A5, click the drop-down arrow, and then select the name of the employee with the lowest number of units sold. Click cell A6, click the drop-down arrow, and then select the name of the employee who sold 30 units to answer question 2. 4 12 Modify the PivotTable as follows: Add the Category field to the PivotTable. Move Category to the FILTERS area. Add the Hotel_Guest field to the PivotTable in the ROWS area under Staff. In cell A15, replace No with Non-hotel Guest Resize column A so Non-hotel Guest is visible. In cell A16, replace Yes with Hotel Guest 8 13 On the Design tab, modify the grand totals so they display for just the columns. Modify the subtotals so they display at the bottom of the group. View the PivotTable data to determine the percentage of revenue for the massage therapists (% of Grand Total). Click cell A8, click the drop-down arrow, and then select the percentage of revenue of massage therapists. 6 14 On the SalesAnalysis worksheet, insert a slicer for the Trans_Type field. Select both cash and check in the Trans_Type slicer. Drag the Trans_Type slicer so the upper left corner is in the top left corner of G12. Drag the bottom edge of the slicer to adjust the height so the extra white space is no longer visible. Replace the Trans_Type caption with Payment Type 8 15 Using the PivotTable, create a Clustered Column PivotChart. Move the PivotChart to a new sheet named SalesChart Add chart title above the chart with the text Percent Revenue Contribution Note, Mac users, select the range A13:D40, then insert a Clustered Column chart. Move the chart and complete the steps as specified. 6 16 Save the workbook, exit Excel, and then submit your files as directed by your instructor. 0 Total Points 100

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Calculation Master
Top Grade Essay
Accounting & Finance Specialist
Engineering Mentor
Financial Hub
Top Academic Tutor
Writer Writer Name Offer Chat
Calculation Master

ONLINE

Calculation Master

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$28 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$18 Chat With Writer
Accounting & Finance Specialist

ONLINE

Accounting & Finance Specialist

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$35 Chat With Writer
Engineering Mentor

ONLINE

Engineering Mentor

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$36 Chat With Writer
Financial Hub

ONLINE

Financial Hub

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$16 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$31 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Short term notes payable examples - Response Required Discussion cloud DBA - Tan inverse 2x tan inverse 3x pi 4 - Jools oliver fish pie - Writershub sign up as a writer - Homework - Discussion 6 - Can you go to juvie for cyberbullying - Draw an aoa network diagram representing the project - Starfleet academy grad at the helm crossword clue - Cultural issues computer science - Toms shoes number of employees - Cornwall college student portal - Point loma nazarene university essay prompt - Alan sugar wife plastic surgery - Evidence based practice - The chair of the operations management department at quality - Wolf of wall street chapter summary - Internal and external factors of entrepreneurship ppt - 5 5 linear automobile depreciation answers - Acute Bronchitis - Advantages and disadvantages of biometrics pdf - Which poet wrote the most poems about tanabata - Week 3 Discussion - How does building new systems produce organizational change - Honig v.doe case brief - The walt disney studios harvard case study analysis - The rising of the moon - Should under god be in the pledge of allegiance - Unit 3 information systems assignment - High clarence primary school - Nursing - Digital/Computer Forensics - The rule that requires financial statements to reflect - Discussion question, 350 words and 2 references. - Analytic - Argument essay - Remote procedure call ppt - Project startup meeting agenda - Insanity case study - Juvenile crime statistics paper cja 374 - Key west lime pie company the profit - Automotive standards for electronics - Reasonable accommodation request letter - How to do domain and range in interval notation - Https www youtube com watch v i47y6vhc3ms - Verandah beam span table - Post - Need to complete chemistry assignment before october 5th. - Module 5 discussion - Cry the beloved country chapter 7 - Beloved wife is not well behaved baka - Information Technology - Compare and contrast suspensions and colloids - Teledyne reynolds high voltage connectors - Fahrenheit 451 creative project ideas - International ngo accountability charter - Biology Big Eared Bat - Stat trek binomial - The six sigma approach to quality control - Why has the typical film editor’s job become more difficult in the last fifty years? - 27 permien street norman gardens - Times they are a changin - 9 kinedana street eden hills - Tidal river camp area - Master of professional psychology deakin - Cell homeostasis virtual lab worksheet answers - (tco 2) according to the loyalists, legitimate authority over the colonists was held by the - Clinical Field Experience C: Roles and Responsibilities of the Special Educator - Outpatient vs hospital presentation - 5 callemondah avenue north gosford - Christianity Presentation - Gos 18 referral form - Costco wholesale corporation financial statement analysis a solution - Wellness assessment and plan paper - Codominance and incomplete dominance practice - Uniform electric field diagram - How to install silverlight - Www macmillanmh com science - Is foreshadowing a dramatic technique - Organizational theory design and change chapter 10 - Bcis online database - Magnetism and its uses - Ap human geography syllabus - Prisoners abroad finsbury park - Difference between nursing conceptual model and nursing theory - Medicaid Medicare - Elite dangerous mining engineering - Final fantasy 14 primal accessories of slaying coffer - Unit IV Case Study(For Dr.Ellen RM) - North tees x ray department - Red comparative and superlative - Pom software - Citric acid + naoh - Ritz carlton target market - Capstone Research Companion - Discussion Response - Cross hatching and stippling - The curious researcher chapter 1 pdf - Fast cat results tool