This is to be done in excel for accounting information system class.please help out with the proper
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.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667f49b225425_970667f49b220ef2.jpg)
Taxation Of Individuals And Business Entities 2019 Edition
ISBN: 9781259918391
10th Edition
Authors: Brian C. Spilker, Benjamin C. Ayers, John Robinson, Edmund Outslay, Ronald G. Worsham, John A. Barrick, Connie Weaver