CREATE A PIVOTTABLE IN A NEW WORKSHEET

  100% Pass and No Plagiarism Guaranteed

CREATE A PIVOTTABLE IN A NEW WORKSHEET

1. Create a PivotTable in a new worksheet as follows:
   1. Display the range named ThirdQ and then insert a PivotTable in a new worksheet.
   2. Add the Attorney LName field as rows.
   3. Add the Area field as columns.
   4. Sum the Fees Due field.
2. Apply the Pivot Style Medium 2 style to the PivotTable (second column first row in the Medium section).
3. Apply comma formatting with no places after the decimal point to the values. Also change the column widths of B through H to 13 characters and right-align the Martinez, O`Donovan, Sullivan, Williams, and Grand Total labels in column A.
4. Name the worksheet PivotTable and then do the following:
   1. In cell A1, type Associate Billing Summary. Change the font to 14-point Copperplate Gothic Bold. Merge and center the text across the PivotTable.
   2. In cell A2, type October - December 2015. Change the font to 14-point Copperplate Gothic Bold. Merge and center the text across the PivotTable.
   3. Change the orientation to landscape and print the PivotTable.
5. Create a PivotChart from the PivotTable using the 3-D Stacked Column chart type and move the chart to its own sheet named PivotChart.
6. Apply Style 7 to the PivotChart (seventh style in the Chart Styles gallery).
7. Filter the PivotChart by the attorney named Martinez.