Ex2016 challenge yourself 5.3 | Accounting homework help

 In this project, you will analyze shoe sales data and use what-if analysis to determine your commission  potential and your sales goal. Skills needed to complete this project: • Converting Data into Tables  • Adding Total Rows to Tables • Removing Duplicate Rows from Tables • Filtering Data • Sorting Data • Inserting a Line Chart • Filtering Chart Data  • Resizing and Moving Chart • Filtering Table Data with Slicers • Creating PivotTables Using Recommended PivotTables • Creating a PivotChart from a PivotTable • Showing and Hiding Chart Elements • Inserting Sparklines • Analyzing Data with Data Tables • Analyzing Data with Goal Seek  This image appears when a project instruction has changed to accommodate an update to  Microsoft Office 365. If the instruction does not match your version of Office, try using the alternate instruction  instead. 1. Open the start file EX2016-ChallengeYourself-5-3. The file will be renamed automatically to include  your name. Change the project file name if directed to do so by your instructor, and save it 2. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top  of the workbook so you can modify the workbook. 3. Convert the shoe sales data in the Sales worksheet into a table. a. Use the Orange, Table Style Medium 3, table style. Use the Table Style Medium 3, table style b. Add a Total row to the table to display the total for the Total Sale column.  c. In the Total row, display the average for the # of Pairs and the Price Per Pair columns. d. Delete any rows in the table that have duplicate data in all the columns. There are four. 4. Filter to show just the sales for the Oregon region. 5. Sort the table by order date with the newest orders first. 6. Insert a line chart to show the total sale amount for each order by order date. a. Create the line chart using just the data from the Order Date and Total Sale columns. Be sure to include  the header row when selecting the data for the chart. Step 1  Download  start fileA Skills Approach: Excel 2016 Chapter 5: Adding Charts and  Analyzing Data 2 | Page Challenge Yourself 5.3 Last Updated 4/3/18 b. There was an ordering glitch on September 8 that caused a spike in sales. Apply a filter to the chart to  hide orders from that date. c. If necessary, move the chart so it does not cover the table data. 7. Add a slicer to the table so you can filter by shoe name. Use the slicer to display data for the Sperry shoe  only. Notice the effect on the chart. 8. Create a PivotTable from the data in the Sales worksheet. Use the Sum of Price Per Pair by Region recommended PivotTable. a. Modify the PivotTable so the Price Per Pair data are averaged, not totaled. b. Add the Shoe field to the PivotTable. It should appear in the Rows section below the Region field. c. Format all the values in the PivotTable using the Accounting Number Format. 9. Create a clustered column PivotChart based on the PivotTable data. Use the first recommended column  chart type. a. Hide the chart title and legend. b. If necessary, move the PivotChart on the worksheet so it does not cover the PivotChart data. 10. Go to the By Region worksheet and add Column Sparklines in F3:F7 for data in columns B3:E7. 11. On the By Region worksheet, create a pie chart to display the sales by region for the Sperry shoe. a. Display the data labels as data callouts. b. Hide the chart legend. c. If necessary, move the chart so it does not cover the table data. 12. You have been told that you will receive a commission between 5 and 10 percent. On the Commission sheet,  make a one‐variable data table using cells A4:B14 to determine how much that commission may be based  on $15,000 in sales. The column input cell is A4. 13. You owe $8,000 in student loans and would like to pay it all off with your commissions. Use Goal Seek to  determine the amount you must sell (cell G5) in order for cell G3 (your commission) to equal $8,000 so  you can fully pay off your student loans. Accept the Goal Seek solution. 14. Save and close the workbook. 15. Upload and save your project file Step 2 16. Submit project for grading. 



Essay Writing Service

Order a unique copy of this paper
(550 words)

Approximate price: $22

Place Order
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.

Zero-plagiarism guarantee

The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.

Read more

Free-revision policy

The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.

Read more

Privacy policy

The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.

Read more

Fair-cooperation guarantee

By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.

Read more

Calculate the price

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
× WhatsApp us for help