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

I love a sunburnt country lyrics - Peyton approved accounting project - Www onetonline org explore interests - Allsteel transportable homes display village edinburgh north sa - Dcl scholarship exam results 2019 - 6 6 challenge problem lawnpro company - Science fair display board - Is africa a country or a continent yahoo answers - Nab company portfolio - How to withdraw negative feedback on ebay - This is a partial adjusted trial balance of barone company - What is a flax dam - The importance of user technology security education within organizations - Casa exams pass rates - What is the relationship between the following two compounds - Week 2 finance - The janowski company has three product lines of mugs - How much time did johnny cash spend in prison - Target market for burger king - Cross modal lexical priming - App inventor multiple screens - Most read bible verses - Al shaqab racing post - Murray's list of needs - It's like pulling teeth a case study in physiology - Determination of the hardness of water lab report - Factorise x 5 x 4 1 - Opportunity cost in transportation problem - How does the price of a motorcycle in Japan compare to other countries? - Informatics in healthcare - How to write a concert report - How to write a cover letter usyd - Captone project - Southern cross ford toowoomba used cars - Week5Acc543 - 100a glencairn avenue brighton east - Feather and bowling ball in vacuum - Acc 202 milestone 1 workbook - Carbon 13 nmr practice problems - Discussion with 250 words and minimum of 2 references - Pr007 work product - Convert density kg m3 to lb ft3 - Alison games atlantic history - Precede proceed model ppt - Cheney manor dental practice - Cracked moment of inertia aci 318 14 - Self control - Where to find working credits centrelink - Economic and Political Globalization - First year of College Seminar D6 - Maternity exemption card opticians - Assignment 1003 - How to lodge a non lodgment advice - The loneliness beyond poem - Employer branding presentation coca cola - Different classes of levers - CSO - Essay Email - Avaya proactive contact supervisor - Do my Powerpoint presentation - Instilling a corporate culture that promotes good strategy execution - Survey of accounting concepts fred jacobs - 520 dis - How do bromeliads adapt to the rainforest - Stata cluster analysis - Atomic radius of potassium - PowerPoint presentation - Traffic light timer circuit - 150 words - Ap statistics quiz 10.3 b answers - What is ima science - Math 144 major assignment 2 - 2 thessalonians 2 6 - Worldview analysis - K-6 drug education resource stage 2 - Disposal of human waste in middle ages - Healthcare reimbursement - MBA assignment - _______ refers to a series of vertical zones with distinctive climate and vegetation regimes. - For researcher_d - How to write a historical context paper - Cisco agent desktop for windows 10 - Druids for the ethical and humane treatment of animals - Simpson 260 service manual - 7 3 proving triangles similar - Marketing Management - Caroma water wafer buttons - Frimley park hospital appointments - Advantages and disadvantages of market penetration ansoff matrix - English file advanced third edition answer key pdf - Centers for disease control influenza vaccine advertising campaign - Capella writing center - 11 lb in kg - The latehomecomer chapter 7 summary - 6 pin accelerator pedal position sensor wiring diagram - Qari ahmad mian thanvi - Hdd 7000 eda diesel generator - Ifsm 300 stage 1 - Call of duty ghosts sys req - MKTG201 Week 5 Assignment 5