Question
My question.: Create a PivotTable based on the range A7:G32. Place the PivotTable in cell I17 on the current worksheet. Place Payment Type in the
My question.:
Create a PivotTable based on the range A7:G32. Place the PivotTable in cell I17 on the current worksheet. Place Payment Type in the Rows box and Amount in the Values box. Format the Amount with Accounting Number Format. |
Insert a PivotChart using the Pie chart type based on the data. Place the upper-left corner of the chart inside cell I22. Format the Legend of the chart to appear at the bottom of the chart area. Format the Data Labels to appear on the Outside end of the chart. |
Insert a Slicer based on Date. Place the upper-left corner of the Slicer inside cell L8. |
B D F G E Beta Manufacturing March Transactions 2 3 1 Search Results Category Quantity Results 8 Status Flag 5 Trans # 30038C 5 7 Date Trans # B 3/1/2018 30038C 3/2/2018 50054F 0 3/3/2018 500510 1 3/3/2018 500510F 2 3/5/2018 10016C 3 3/7/2018 50055C 4 3/9/2018 10015C 5 3/10/2018 50053C 6 3/10/2018 20021F 7 3/10/2018 40044F 8 3/11/2018 20029F 9 3/11/2018 30038C 0 3/12/2018 10019F 1 3/13/2018 20028F 2 3/13/2018 20029C 3 3/14/2018 30039C 4 3/18/2018 30031C 5 3/24/2018 400410 6 3/24/2018 40043F 7 3/24/2018 400410C 8 3/28/2018 200210C 9 3/28/2018 10019C 0 3/30/2018 30038C 1 3/30/2018 40046F 2 3/30/2018 200290 Flag Item Quantity Payment Type 3003 8 Credit 5005 4 Financed 5005 1 Credit 5005 10 Financed 1001 6 Credit 5005 5 Credit 1001 5 Credit 5005 3 Credit 2002 1 Financed 4004 4 Financed 2002 9 Financed 3003 8 Credit 1001 9 Financed 2002 8 Financed 2002 9 Credit 3003 9 Credit 3003 1 Credit 4004 1 Credit 4004 3 Financed 4004 10 Cash 2002 10 Credit 1001 9 Cash 3003 8 Credit 4004 6 Financed 2002 9 Cash Amount $4,800 $2,800 $700 $7,000 $1,500 $3,500 $1,250 $2,100 $500 $2,600 $4,500 $4,800 $2,250 $4,000 $4,500 $5,400 $600 $650 $1,950 $6,500 $5,000 $2,250 $4,800 $3,900 $4.500 Flag Flag Flag Flag
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started