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%