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

Aircraft seat track fittings - Radioactive dating game lab worksheet answers - The artichoke version of the self - W5Assgnment PsychoPharmacolog - Agarose gel voltage per cm - Guide to national quality standard acecqa 2011 - What did cinderella say to the photographer math worksheet - At year end the perpetual inventory records - English Comp 2 week 9 - Philosophy here and now vaughn pdf - Desiderata for controlled medical vocabularies in the twenty first century - ARTS 1301 - Force equals mass times acceleration - Joe henry's machine shop uses 2500 brackets - The polyvinyl chloride bar is subjected to an axial - Knauf 76 x 3000mm steel wall track - Benchmark patient's spiritual needs case analysis - Seoul national university academic calendar - Tcp ip attack lab solution - Class b push pull amplifier - Analyzing an Argument Essay - University of phoenix organizational management - Measuring internal resistance using potentiometer - The manager of a burger doodle franchise - Describe the appearance of a dry owl pellet - Anyone who had a heart by phil stephens answers - Hydrated copper ii sulfate formula - Future of the juvenile justice system proposal presentation - Internal Persuasive Proposal using toulmin model - Nantucket hammocks inc uses dealer incentives - Major steps in accounting process - Www ilc org career matters - Nursing - Semester 2 dates uts - Offense cycle - Why should student have cell phones in school - Policy Implementation - Why doesn't george help lennie in the fight - Nursing - Westwood publishing case study answer - P4 28a accounting - Amazon push pull strategy - Saving my first kiss by lisa velthouse pdf - Propagation of error excel - Project management - Temple university data analytics challenge - Six hugs and rock and roll outlet - Video worksheet sicko answers - Torbay council parking permits - Upper fence and lower fence - Discussion 08/19 - Mini ice plant business - Remember the titans true story - Romeo and juliet study guide questions and answers act 2 - Convergence and reshaping of mass communication - Nintendo switch error code 2107 0401 - Introduction to the bible syllabus - Testout Network Pro Certification exam - Www bbc co uk guides z3c6tfr - Budgeting - Carbonite evaluating list of files to download - How to make a fairy tale book - Capital budgeting questions and answers pdf - What makes bubble gum stretchy - Is post apocalyptic a genre - Writing assignment 3 - Peter symonds student intranet - Case Study on Death and Dying - Will galvanized steel rust in concrete - Pensioner services online pss - Critical issues in education dialogues and dialectics 8th edition - Why do you think daisy sobs - Select E-commerce industry and highlight the advancements Blockchain has had on that industry. - Apply moderate effect smartart style powerpoint - Toms case study business strategy - A private college advertised that last year - Daphnia heart rate temperature lab report - Elliott heads foreshore development - Module 3 lecture questions - Powerpoint - Monsanto syngenta mega merger would drive more deals real m&a - Theme of death by scrabble - Information tech - Security - Formal vs informal language - Dust echoes abc aboriginal stories - Disadvantages of advertising to consumers - How does salt water affect gummy bears - The term shaman comes from the tungus language of: - Voices of freedom eric foner volume 2 3rd edition pdf - 106a pulsford road prospect - Riot shield parts shadows of evil - Janson medical clinic case study - I need a paper typed ASAP - What age does hooters hire - Http www beaconlearningcenter com - Define traceability in metrology - Lynsi martinez in and out - Their eyes were watching god narrator - Shoreline stadium case study answers