This is to be done in excel for accounting information system class please help out with the proper steps thanks 1 Go to the Sales by Client worksheet Nadia created a PivotTable named ClientPivot that lists sales by client and state, but she wants to simplify the PivotTable by displaying the sales by client and region Manually group the CT, NJ, and NY column labels (cells B3, E3, and F3) Use North as the name of the group Manually group the GA and FL column labels in row 4 and use South as the name of the group Remove the State field from the Columns area Rename the State2 field to use Region as the custom name Sort the South values in ascending order to list first the North sales amounts in column B followed by the South sales amounts in column C Hide the field headers to further streamline the layout NP EX19 EOM11 1 RochiBorbon 2 Q Search Sheet Insert Page Layout Formulas ' Share Home Data Review View PivotTable Analyze Design PivotTable Name Active Field Expand Field ClientPivot Options State Field BE Collapse Field Group Insert Insert Filter Refresh Change Clear Select Move Fields, PivotChart Field Field Settings Selection Slicer Timeline Connections Data Source PivotTable Items, Sets List Buttons Headers Office Update To keep up to date with security updates, fixes, and improvements, choose Check for Updates Check for Updates F3 X V fx NY C D E F G H K M N PivotTable Fields QUALEY CONSULTING SALES BY CLIENT FIELD NAME Q Search fields Sum of Total Sales Column Labels O Service 3 Row Labels CT FL GA NJ NY Grand Total 4 ASHBY $39,105 $39,105 Client ID 5 CLAU $60,095 $60,095 O Category 6 FLATH $37,035 $37,035 HARRA 538,220 $38,220 State 8 KERRA $35,945 $35,945 Start Date 9 LUCIO $30,010 $30,010 10 MIRSS $32,835 $32,835 11 $20,055 $20,055 Filters Ill Columns 12 RENOR $47,155 $47,155 13 $9,990 $9,990 State 14 Grand Total $47,155 $52,890 $76,140 $98,315 $75,9451 $350,445 15 16 17 18 19 20 Rows Values Client ID Sum of Total Sales Drag fields between areas D Documentation Sales Report Sales by Category Sales by Client Sales by Service Ready Average 37972 5 Count 5 Sum 151890 100

Question

This is to be done in excel for accounting information system class please help out with the proper steps  thanks 1 Go to the Sales by Client worksheet  Nadia created a PivotTable named ClientPivot that lists sales by client and state, but she wants to simplify the PivotTable by displaying the sales by client and region  Manually group the CT, NJ, and NY column labels (cells B3, E3, and F3)  Use North as the name of the group  Manually group the GA and FL column labels in row 4 and use South as the name of the group  Remove the State field from the Columns area  Rename the State2 field to use Region as the custom name  Sort the South values in ascending order to list first the North sales amounts in column B followed by the South sales amounts in column C  Hide the field headers to further streamline the layout   NP EX19 EOM11 1 RochiBorbon 2 Q   Search Sheet Insert Page Layout Formulas '  Share Home Data Review View PivotTable Analyze Design PivotTable Name  Active Field  Expand Field   ClientPivot Options State Field BE Collapse Field Group Insert Insert Filter Refresh Change Clear Select Move Fields, PivotChart Field     Field Settings Selection Slicer Timeline Connections Data Source PivotTable Items,   Sets List Buttons Headers Office Update To keep up to date with security updates, fixes, and improvements, choose Check for Updates Check for Updates F3 X V fx NY C D E F G H K M N PivotTable Fields QUALEY CONSULTING SALES BY CLIENT FIELD NAME Q  Search fields Sum of Total Sales Column Labels O Service 3 Row Labels CT FL GA NJ NY Grand Total 4 ASHBY $39,105 $39,105 Client ID 5 CLAU $60,095 $60,095 O Category 6 FLATH $37,035 $37,035 HARRA 538,220 $38,220 State 8 KERRA $35,945 $35,945 Start Date 9 LUCIO $30,010 $30,010 10 MIRSS $32,835 $32,835 11 $20,055 $20,055 Filters Ill Columns 12 RENOR $47,155 $47,155 13 $9,990 $9,990   State 14 Grand Total $47,155 $52,890 $76,140 $98,315 $75,9451 $350,445 15 16 17 18 19 20 Rows   Values   Client ID   Sum of Total Sales Drag fields between areas D Documentation Sales Report Sales by Category Sales by Client Sales by Service   Ready Average  37972 5 Count  5 Sum  151890   100

Accepted Answer

The Answer is in the image, click to view ...

This is to be done in excel for accounting information system class.please help out with the proper

Question:

Taxation Of Individuals And Business Entities 2019 Edition

This is to be done in excel for accounting information system class.please help out with the proper

Question:

Expert Answer:

The Answer is in the image, click to view ... View the full answer

Taxation Of Individuals And Business Entities 2019 Edition

Students also viewed these Accounting questions