Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Inventory

Authors: Steven M. Bragg

4th Edition

1642210714, 9781642210712

More Books

Students also viewed these Accounting questions

Question

What attracts you about this role?

Answered: 1 week ago

Question

How many states in India?

Answered: 1 week ago

Question

HOW IS MARKETING CHANGING WITH ARTIFITIAL INTELIGENCE

Answered: 1 week ago

Question

Explain the impact of organizational culture on employees.

Answered: 1 week ago