- 18 19 Make The Orders Data An Actual Excel Table Name The Table Ordertable Figure Sense One Way To Check Your Ans 1 (42.39 KiB) Viewed 20 times
- 18 19 Make The Orders Data An Actual Excel Table Name The Table Ordertable Figure Sense One Way To Check Your Ans 2 (42.39 KiB) Viewed 20 times
- 18 19 Make The Orders Data An Actual Excel Table Name The Table Ordertable Figure Sense One Way To Check Your Ans 3 (53.33 KiB) Viewed 20 times
- 18 19 Make The Orders Data An Actual Excel Table Name The Table Ordertable Figure Sense One Way To Check Your Ans 4 (31.1 KiB) Viewed 20 times
- 18 19 Make The Orders Data An Actual Excel Table Name The Table Ordertable Figure Sense One Way To Check Your Ans 5 (46.03 KiB) Viewed 20 times
- 18 19 Make The Orders Data An Actual Excel Table Name The Table Ordertable Figure Sense One Way To Check Your Ans 6 (41.81 KiB) Viewed 20 times
- 18 19 Make The Orders Data An Actual Excel Table Name The Table Ordertable Figure Sense One Way To Check Your Ans 7 (51.77 KiB) Viewed 20 times
20. Insert a new Pivot Table based on the OrderTable into a new worksheet named PT2. Move the PT2 worksheet so that it is directly to the right of the PT1 worksheet. Remove the gridlines from the PT2 worksheet. Replicate this PivotTable: H B D E G 1 2 3 Sum of Total Column Labels 4 Row Labels - Central East Northeast South West Grand Total 5 Adam Grossman $10,498.92 $7,679.42 $1,532.26 $3,080.23 $5,397.66 $28,188,48 6. Michelle Grant $8,824.02 $4,307.20 $3,941.22 $2,707.27 $2,953.34 $22,733.05 7. Susan Peters $9,392.02 $4,973.15 $9,595.01 $2,537.07 $3,708.69 $30,205.93 8 Timothy James $6,994.34 $1,235.95 $10,205.52 $3,839.53 $6,613.70 $28,889.03 9 Grand Total $35,709.29 $18,195.72 $25,274.00 $12,164.09 $18,673.39 $110,016.49 10 11 Order Date 12 13 Mar - Jun 2021 MONTHS 14 2021 15 JAN FEB MAR JUN SEP OCT NOV D 16 17 APR MAY JUL AUG
21. Insert a new PivotTable based on the Order Table into a new worksheet named PT3. Move the PT3 worksheet so that it is directly to the right of the PT2 worksheet. Remove the gridlines from the PT3 worksheet. Create a PivotTable that shows the total dollar amount for each unique order. For example, Order ID SP 1004 consists of multiple jerseys. The PivotTable should show just one row for Order ID SP1004 with a total dollar amount of $848.10. Make sure to format the amounts as Currency with two decimal places.
22. Insert a new Pivot Table based on the OrderTable into a new worksheet named PT4. Move the PT4 worksheet so that it is directly to the right of the PT3 worksheet. Remove the gridlines from the PT4 worksheet. Replicate this Pivot Table: B D E G H State Name Bengals Alabama Alaska Arizona Arkansas 3 Row Labels Sum of Quantity 4. Adam Grossman 42 5 Michelle Grant 28 6 Susan Peters 7 7. Timothy James 16 8 Grand Total 93 9 10 Team 11 12 49ers Bears 13 Bills 14 Broncos 15 Buccaneers Cardinals 16 Chiefs Colts 17 18 Dolphins Eagles 19 Giants Jaguars 20 21 Uons Packers 22 Patriots Raiders 23 24 Ravens Saint Browns California Connecticut Delaware Florida Georgia Idaho Illinois Towa Chargers Cowboys Falcons Kansas Louisiana Kentucky Michigan Massachuse... Minnesota Maryland Mississippi Nevada New York Jets Missouri Montana Nebraska Panthers New Jersey New Mexico New Hamps... North Dakota Panneanis Ohio Oklahoma Rams Seahawks Oregon Sitharoli South Dakota Tennes
State Name 92 Bengals Alabama Alaska Arizona Arkansas Florida Browns California Connecticut Delaware Georgia Idaho Illinois Iowa Chargers Cowboys Louisiana 3 Row Labels Sum of Quantity 4 Adam Grossman 42 5 Michelle Grant 28 6 Susan Peters 7 7 Timothy James 16 8 Grand Total 93 9 10 Team 11 12 49ers Bears 13 Bils Broncos 14 15 Buccaneers Cardinals 16 Chiefs Colts 12 18 Dolphins Eagles 19 20 Giants Jaguars 21 Lions Packers 22 Patriots Raiders 23 24 Ravens Saints 25 Steelers Texans 26 27 Vikings Washington 28 29 30 31 32 Kansas Massachuse. Falcons Kentucky Michigan Montana Minnesota Maryland Mississippi Nevada Jets Missouri Nebraska Panthers New Jersey New Mexico New York New Hamps.. North Dakota Pennsylvania Ohio Rams Seahawks Oklahoma Oregon Tennessee South Caroli. South Dakota Titans Utah Vermont West Virginia Hawaii Wisconsin Virginia Colorado North Caroli Wyoming Indiana Maine Rhode Island Texas Washington
D G 1 Order Salesperson Order Date Ship To State Name Region Product 2 MG1000 Michelle Grant 1/1/2021 9.UT-28 Utah West Texans Jersey 3 SP1000 Susan Peters 1/1/20214-WY-BS Wyoming West Buccaneers Jersey 4 SP1001 Susan Peters 1/1/2021 2-D-83 Idaho West 49ers Jersey 5 T1000 Timothy James 1/1/2021 2-L-24 illinois Central Dolphins Jersey 6 T11001 Timothy James 1/1/2021 1-C0-77 Colorado West Chiefs Jersey 7 T/1001 Timothy James 1/1/2021 1-C0-77 Colorado West Broncos Jersey B MG1001 Michelle Grant 1/2/2021 9-TN-76 Tennessee East Panthers Jersey 9 SP1002 Susan Peters 1/2/2021 2.K5.90 Kansas Central Broncos Jersey 10 SP1003 Susan Peters 1/2/2021 5-MT-60 Montana West Packers Jersey 11 T31002 Timothy James 1/2/2021 4-10-45 Idaho West Packers Jersey 12 MG1002 Michelle Grant 1/3/2021 1 VA 83 Virginia East Falcons Jersey 13 SP1004 Susan Peters 1/3/2021 9-CA 15 California West Rams Jersey 14 SP1004 Susan Peters 1/3/2021 9.CA 15 California West Jaguars Jersey 15 SP1004 Susan Peters 1/3/2021 9-CA-15 California West Texans Jersey 16 SP1004 Susan Peters 1/3/2021 9.CA-15 California West Dolphins Jersey 17 SP1004 Susan Peters 1/3/2021 9-CA-15 California West Colts Jersey 18 T 1003 Timothy James 1/3/20216-AR-37 Arkansas South Dolphins Jersey 19 MG1003 Michelle Grant 1/4/2021 1-TX 27 Texas South Chiefs Jersey 20 MG1004 Michelle Grant 1/4/2021 2 AX-77 Alaska West Falcons Jersey 21 T)1004 1/4/2021 4-AK 24 Timothy James Packers Jersey Alaska West Michelle Grant 1/5/2021 7-AK-65 22 MG1005 Alaska West Rams Jersey Alama South T11005 1/5/2021 4 AL 13 Patriots large Timnthy lames Orders States Prices PT1 Discounts Questions 11 16 Quantity Price Discount Total Team Free Gift 1 $84.52 OR$8452 Texans 2 $79.99 OR $159.98 Buccane 8 $99.95 10% 5719.64 49ers 8 $85.50 10% 561560 Dolphin 1 $99.95 0% $99.95 Chiefs 2 $89.99 OR $179.98 Broncos 1 $62.89 0% $62.89 Panther 3 $89.99 0% 5269.97 Broncos & $0.99 10% $583.13 Packers 2 $0.99 0 $161.98 Packers 7 $85.99 10% $541.74 Falcons 6 $6099 10% $329,35 Rams 1 $61.89 0% $61.89 laguars 2 584.52 0% $169.04 Texans 1 $8.50 0% $85.50 Dolphin 3 $70.99 5% $202 32 Colts 5 $85.50 10% $184.75 Dolphin 6. $99.95 10% $539.73 Chiets 5 $85.99 10% $136.96 Falcons 3 $90.99 5% $230.82 Packers 1 $60.99 0% $60.99 Rams 1 $9200 0992.09 Patriots 4451