Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help with Excel function. Show how you did it Home Tent Duwe Lyout Format Data Vw Pivottable De Comments e Share 9 k125270.1 0

Please help with Excel function. Show how you did it
image text in transcribed
image text in transcribed
image text in transcribed
Home Tent Duwe Lyout Format Data Vw Pivottable De Comments e Share 9 k125270.1 0 Pivot Table Fields RowLabels Sum of Sales chant 584124 5 there 5136,407 and Garden 5111,60921 Tube 51331664 ber 5122-2017 Morine 5325.270.10 10 51147 11 Alle 5101, 12 Total $1,003,79 19 10 3. Copy the PT1 worksheet to a new worksheet named PT2. Notice that you are creating a copy of the entire PT1 worksheet, not just the actual PivotTable! Rearrange the fields in the PivotTable to analyze department sales by quarter. Use conditional formatting to apply a yellow fill color to the cells that represent the highest quarterly sales amount in each of the four quarters. A X Calibri 11 A Paste BI UB v Undo Clipboard Is Font H19 Xfx B D 1 2 3 Row Labels Sum of Sales 4 Kitchen and Bath $141,409.24 5 Electric $136,430.77 6 Lawn and Garden $131,609.21 7 Plumbing $129,866.94 8 Lumber $127,774.93 9 Flooring $125,270.10 10 Paint $114,739.72 11 Appliances $101,698.91 12 Grand Total $1,008,799.82 13 14 15 16 17 WN 600 O un 18 19 20 21 22 23 24 25 26 27 28 29 30 Home Tent Duwe Lyout Format Data Vw Pivottable De Comments e Share 9 k125270.1 0 Pivot Table Fields RowLabels Sum of Sales chant 584124 5 there 5136,407 and Garden 5111,60921 Tube 51331664 ber 5122-2017 Morine 5325.270.10 10 51147 11 Alle 5101, 12 Total $1,003,79 19 10 3. Copy the PT1 worksheet to a new worksheet named PT2. Notice that you are creating a copy of the entire PT1 worksheet, not just the actual PivotTable! Rearrange the fields in the PivotTable to analyze department sales by quarter. Use conditional formatting to apply a yellow fill color to the cells that represent the highest quarterly sales amount in each of the four quarters. A X Calibri 11 A Paste BI UB v Undo Clipboard Is Font H19 Xfx B D 1 2 3 Row Labels Sum of Sales 4 Kitchen and Bath $141,409.24 5 Electric $136,430.77 6 Lawn and Garden $131,609.21 7 Plumbing $129,866.94 8 Lumber $127,774.93 9 Flooring $125,270.10 10 Paint $114,739.72 11 Appliances $101,698.91 12 Grand Total $1,008,799.82 13 14 15 16 17 WN 600 O un 18 19 20 21 22 23 24 25 26 27 28 29 30

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

Students also viewed these Finance questions

Question

1. What are the two major causes of variation? Explain each one.

Answered: 1 week ago