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

Lord of the flies excerpt - Hidden secrets answers - Miss clairol short story - Cyclic olefin copolymer chemical compatibility - MK630 Wk1Ip - Big sugar lake okeechobee - Why do halogens exist as diatomic molecules - Lesson 5.2 skills practice answers downtown and uptown answers - Lab wildcam gorongosa - In what ways has dispossession continued to affect aboriginal spiritualities - Pencil manufacturing process ppt - How to sign up for moshi monsters - Latent heat of saturated steam - Anu final exam timetable - Ssl / tls renegotiation handshakes mitm plaintext data injection - Writing Help - Issa fitness nutrition exam section 1 - Max workouts pdf torrent - Sedgemoor auction centre market reports - Direct labor rate per hour - Which nuclear structure s contain s the hereditary material - Why Amazon is Worth $1 Trillion - Small Buisness Management Discussion - Ford cost of goods sold - Hyundae fitting co ltd - Statistic - Not till then how much i owe - Woodlands junior tudor food - What are bone markings - Plantwide overhead rate example - Deakin university waurn ponds postcode - Chrome flags enable site per process - Best tv commercial scripts - Games strategies and decision making exercise solutions - Answer these questions from the film from Netflix "Even the rain y tambien la lluvia" - Racv locked out of house - Problem statement for event management system - Car sales system project in java - Spiritual meaning of geshem - Bluebird mfg has received a special - Wk 8-2 - Www video blue eyes com - Reset hudl 2 password - Calcium carbonate in eggshells - Book Review Of The Glass Castle - Beery vmi 6th edition - Judeo christian and greco roman perspectives answers - Imca dp guidelines pdf - Prego 1b - A company's broad "macro-environment" refers to - Introduction to management science with spreadsheets bernard w taylor - What does blue ocean mean - Tom trusock cause of death - How to make wbs in word - Beweep in a sentence - Igcse chemistry past paper questions by topic - 1 to 5 rating scale labels - Why is mary reibey on the $20 note - Accounting - Cosi louis nowra quotes - New england journal of entrepreneurship - Covalent bonding practice problems answers - Death Penalty in America 2 - Bank cheque commonwealth bank - Hydrobenzoin density g ml - Walmart business ethics and social responsibility - Thorlabs lens cleaning tissue - Personal responsibility paper - Epidemiology - Big Data Visualization - Strayer university cyber security - Sesshu painted in a style that was called haboku meaning - Understanding gender - Raa membership levels bronze - Pr9 - A matter of facts - Is gabbro volcanic or plutonic - Lion king hamlet similarities - Case study on total quality management with solution - Symbols of a circuit - Viernes ul - Journal article critique apa format - Chuck e cheese token prices 2014 - Search for my tongue essay - Harry potter and the prisoner of azkaban hero's journey - Interesting facts about prince henry the navigator - Roc flx craft beverage trail passport - Rules for solving equations - CPSC 355 Assignment 3 - Plastral malaga opening hours - Alam company is a manufacturing firm - Billy blue bachelor of digital media - Essentials of health information systems and technology balgrosky pdf - County farms to let - Owasp secure coding practices quick reference guide 2017 - What forces act as stimulants to change - Elephant toothpaste lab report - Workshop-2 Essay - Root word meaning cell - How to separate sand and salt