8. Create a Pivot Table from the data in the Sales worksheet. Use the Sum of Price Per Pair by Region recommended Pivot Table. a. Modify the Pivot Table so the Price Per Pair data are averaged, not totaled. b. Add the Shoe field to the Pivot Table. It should appear in the Rows section below the Region field. c. Format all the values in the Pivot Table using the Accounting Number Format. 9. Create a clustered column PivotChart based on the Pivot Table data. Use the first recommended column chart type. Hide the chart title and legend. a. b. If necessary, move the Pivot Chart 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. Display the data labels as data callouts. a. b. Hide the chart legend. if necessary, move the chart so it does not cover the table data. 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 $17,000 in sales. The column input cell is A4. 12. 13. You owe $9,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 GS) in order for cell G3 (your commission) to equal $9,000 so you can fully pay off your student loans. Accept the Goal Seek solution. Save and close the workbook 14. 15. 16. Upload and save your project file. Submit project for grading

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question
Mark the steps as checked when you complete them.
1. Open the start file EX2019-Challenge Yourself-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. It is the third option in the Medium section of the gallery.
Add a Total row to the table to display the total for the Total Sale column.
b.
In the Total row, display the average for the # of Pairs and the Price Per Pair columns.
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 Washington 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.
d.
b. There was an ordering glitch on August 31 that caused a spike in sales. Apply a filter to the chart to hide orders
from that date. Notice the effect on the chart
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
Transcribed Image Text:Mark the steps as checked when you complete them. 1. Open the start file EX2019-Challenge Yourself-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. It is the third option in the Medium section of the gallery. Add a Total row to the table to display the total for the Total Sale column. b. In the Total row, display the average for the # of Pairs and the Price Per Pair columns. 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 Washington 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. d. b. There was an ordering glitch on August 31 that caused a spike in sales. Apply a filter to the chart to hide orders from that date. Notice the effect on the chart 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
Mark the steps as checked when you complete them.
1. Open the start file EX2019-Challenge Yourself-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. It is the third option in the Medium section of the gallery.
Add a Total row to the table to display the total for the Total Sale column.
b.
In the Total row, display the average for the # of Pairs and the Price Per Pair columns.
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 Washington 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.
d.
b. There was an ordering glitch on August 31 that caused a spike in sales. Apply a filter to the chart to hide orders
from that date. Notice the effect on the chart
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
Transcribed Image Text:Mark the steps as checked when you complete them. 1. Open the start file EX2019-Challenge Yourself-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. It is the third option in the Medium section of the gallery. Add a Total row to the table to display the total for the Total Sale column. b. In the Total row, display the average for the # of Pairs and the Price Per Pair columns. 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 Washington 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. d. b. There was an ordering glitch on August 31 that caused a spike in sales. Apply a filter to the chart to hide orders from that date. Notice the effect on the chart 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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 17 images

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education