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 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