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.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Our Services
Custom Writings Help is a Quality-Oriented Company in Online Writing as a result of hiring exceptional professionals to execute clients' tasks.
Essays
At Custom Writings Help,We understand the struggle of research paper writing, and that is why at Custom WritingS Help, we are all out to help you. We pride ourselves on having a team of clinical writers. The stringent and rigorous vetting process ensures that only the 'BEST' Writers are chosen for the job. We have highly qualified Ph.D. and MA writers working with us; we equally offer these experienced writers specific bonuses and incentives to make them deliver highly original, unique, and informative content at reasonably low prices.
Admissions
Thesis Writing Service
Worlwide, Many Masters Students are struggling with Thesis Completion. A thesis is likely to be the longest and most challenging piece of work a student has ever completed. However, unlike essays and other assignments, a student can pick a particular interest topic and work on their initiative. Fortunately, we are there for you. At Custom Writings Help, you are assured of an authentic, imaginative, informative, linguistically great, and advantageous thesis that adheres to all your needs. So, why continue considering different writers when you have discovered the best in the field?
Editing
Custom Papers
Not a single student can avoid writing custom papers. However, a total lack of experience, skills, and time makes it very hard to produce a superb writing piece. Therefore, if you are seeking professional help, turn to us. Our specialized and experienced writers compose a variety of model papers, including custom essays, college term papers, research papers, book reports, MBA essays, executive summaries, dissertations, Ph.D. theses, admission essays, and research proposals for college and university students at any level.
Coursework
Essay Writing
Most of the students disregard the critical principles of essay writing and compose papers below sensible guidelines. Therefore, with Custom Writings Help, one should not worry about his/her essay. Our Writers compose informative and engaging content on all complexities and topics. We write meaningful and smart essays while prioritizing all aspects that bring about a good grade, such as impeccable grammar, proper structure, zero-plagiarism, and conformance to guidelines.
Coursework
Coourse Work Writing
Don't let the seemingly never-ending onslaught of writing assignments get you down. If you are looking where to get course work assistance online, the writers at Custom Writings Help are here to assist you with all of your writing needs. We undertake to unique delivery of papers that meet the professor's requirements. The content is proofread, edited, and checked plagiarism before submission to customers. No matter how big or small your work is, we will deliver on time. Try US Now! !
Coursework
Dissertation Writing Service
High-Quality Dissertation Writing Services are rare. They require Ph.D. academicians – not easily found. However, are an exception. The years, time, and resources we have invested in the dissertation world has given us a competitive advantage over others. Choose to come to Custom Writings Help; You will find perfect Ph.D. consultants who have written hundreds of dissertations theses ready to help you. Let our dissertation-writing services help you craft your dissertation, for you are assured we will give you the results.