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

Week 4 Assignment: Searching and Evaluating Cultural and/or Ethical Resources (Weekly Written Assignment) - The financial statements of lioi steel fabricators - The dgi data governance framework - The 4 p's of marketing - What are the three types of malware that have the primary traits of circulation and/or infection? - Centurion d5 evo low battery - Reflection Paper - What is universal standards in e commerce - Bbc dance mat touch typing - Welsh south road national - Greek mythology research topics - Dichotomous key examples for dogs - Hcf gold extras product summary - Product of 3 consecutive numbers - The bad boy blueprint - Informative speech about water pollution - A tiger leaps horizontally from a - 2 way manova spss - Explorations conducting empirical research in canadian political science pdf - Journal Entry - Amu croydon university hospital - Glasgow angling centre catalogue - The new york house of refuge - Capstone Research Companion - What determines the price and quantity of most goods - What is the epic hero cycle - Discussion - Questions for act one of the crucible answer key - Wgu c170 donut shop - What is the function of the nslookup utility? - PROBLEM SOLVING DISCUSSION - 6.2 properties of parallelograms - Stp software test plan - Only the monstrous anger of the guns analysis - Kant's Ethics and Our Duty- APA 1 PARAGRAPH with References - Thomson's charge to mass ratio - Muslim Molvi 7340613399 OnLine No 1 FaMOUs VashIKaraN sPecIaLIsT IN Bokaro - Domyos which country brand - Beaufort wind scale chart - Lead and manage team effectiveness - Massachusetts government act definition - Pressure variation in static fluid - Unit 9 - Linear loaded vertical antenna - Fife council nursery application - Quality tactics and the logistics and supply chain functions - Acc 202 milestone 1 - How to find all asymptotes of a rational function - Professional capstone and practicum reflective journal - In the design and development department of China's small and medium-sized electronic game companies, flexible human resource management will have an impact on employee loyalty. - A biological community's productivity is a measure of - Errors commonly committed in a business letter - Godmanchester dog training club - Monash law winter units 2021 - 978 0 07 803475 6 - Risk breakdown structure for a wedding - Cim certificate in professional marketing official module guide - Anna meares now big w - 9 nicole place winmalee - Is 147/80 high blood pressure - WRD 204 Writing Exercise 4: Usability Analysis - Construct a binomial probability distribution with the given parameters - Lightning protection rolling sphere method - Statistics HW- Need tomorrow - Accommodations for diverse learners - Topic 4: Application of Research-1 - Define exemplar in forensics - Gib head key dimensions - Bankstown girls high school ranking - What is a concrete detail in an essay - Describe the different types of logistics service providers - N gregory mankiw principles of economics 6th edition pdf - Single phase ac voltage controller ppt - Mendel and heredity worksheet answer key - Order 2420519: Maximize Instruction through PD - Netflix value chain analysis - How to write an encryption program in c++ - How to calculate piecework - Kronos and zeus notes - Cuando mi hermano era niño tener muchas alergias - Genitalia soap note - The pitcher poem - The ideal lot size for a lean system is - A gallon of paint covers about square feet - Help with essay - Csec english sba reflection sample - Employee services include all of the following except - Salesforce certified b2c commerce developer - Silver nitrate reacts with sodium hydroxide - An old black ram is tupping your white ewe analysis - Service Encounter Journal, One page, Pick category #1 or #2 to write - Applying ethical theories to case studies - Memo 3 - Using the indirect method patent amortization expense for the period - Collage Scene teaching - Epidemiology SLP 3 - Write answers to the questions in your notebook - Dr kaoru ishikawa biography - Validating node self description database riverbed - Primary school leadership speech