Trans # 30038C Trans # Date 3/1/2021 30038C 3/2/2021 50054F 3/3/2021 50051C 3/3/2021 500510F 3/5/2021 10016C...

Transcribed Image Text:

Trans # 30038C Trans # Date 3/1/2021 30038C 3/2/2021 50054F 3/3/2021 50051C 3/3/2021 500510F 3/5/2021 10016C 3/7/2021 50055C 3/9/2021 10015C 3/10/2021 50053C 3/10/2021 20021F 3/10/2021 40044F 3/11/2021 20029F 3/11/2021 30038C 3/12/2021 10019F 3/13/2021 20028F 3/13/2021 20029C 3/14/2021 30039C 3/18/2021 30031C 3/24/2021 40041C 3/24/2021 40043F 3/24/2021 400410C 3/28/2021 200210C 3/28/2021 10019C 3/30/2021 30038C 3/30/2021 40046F 3/30/2021 20029C Search Results Category Quantity Results Item 3003 5005 5005 5005 1001 5005 1001 5005 2002 4004 2002 3003 1001 2002 2002 3003 3003 4004 4004 4004 2002 1001 3003 4004 2002 Quantity Payment Type Credit Financed Credit Financed Credit Credit Credit Credit Financed Financed Financed Credit Financed 8 Financed Credit Credit Credit Credit Financed Cash Credit Cash Credit Financed Cash 8 4 1 10 6 1 4 9 9 3 10 10 8 9 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 Status Flag Flag Flag Flag $1,950 $6,500 $5,000 $2,250 $4,800 Flag $3,900 $4,500 Flag 24 25 26 27 Enter a nested lookup function in cell F5 that evaluates the Trans # in cell B5 as well as the Category in cell D5, and returns the results based on the data in the range A8:F32. Create a PivotTable based on the range A7:G32. Place the PivotTable in cell 117 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 122. 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. 3 5 + 3 Trans # 30038C Trans # Date 3/1/2021 30038C 3/2/2021 50054F 3/3/2021 50051C 3/3/2021 500510F 3/5/2021 10016C 3/7/2021 50055C 3/9/2021 10015C 3/10/2021 50053C 3/10/2021 20021F 3/10/2021 40044F 3/11/2021 20029F 3/11/2021 30038C 3/12/2021 10019F 3/13/2021 20028F 3/13/2021 20029C 3/14/2021 30039C 3/18/2021 30031C 3/24/2021 40041C 3/24/2021 40043F 3/24/2021 400410C 3/28/2021 200210C 3/28/2021 10019C 3/30/2021 30038C 3/30/2021 40046F 3/30/2021 20029C Search Results Category Quantity Results Item 3003 5005 5005 5005 1001 5005 1001 5005 2002 4004 2002 3003 1001 2002 2002 3003 3003 4004 4004 4004 2002 1001 3003 4004 2002 Quantity Payment Type Credit Financed Credit Financed Credit Credit Credit Credit Financed Financed Financed Credit Financed 8 Financed Credit Credit Credit Credit Financed Cash Credit Cash Credit Financed Cash 8 4 1 10 6 1 4 9 9 3 10 10 8 9 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 Status Flag Flag Flag Flag $1,950 $6,500 $5,000 $2,250 $4,800 Flag $3,900 $4,500 Flag 24 25 26 27 Enter a nested lookup function in cell F5 that evaluates the Trans # in cell B5 as well as the Category in cell D5, and returns the results based on the data in the range A8:F32. Create a PivotTable based on the range A7:G32. Place the PivotTable in cell 117 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 122. 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. 3 5 + 3

Answer rating: 100% (QA)

It seems youve shared an image with a data set and a set of Excelrelated tasks you need to perform with the data However as an AI Im unable to directl... View the full answer