# CIS 114DE Assessment 4

Question # 00546009 Posted By: Prof.Longines Updated on: 06/14/2017 01:22 AM Due on: 06/14/2017
Subject Computer Science Topic Algorithms Tutorials:
Question

Assessment 4: Summarize Data in A Pivot Table and Pivot Chart.

1.) Open BillingSummary3q.xlsx

2.) Save the workbook and name it EL2-C4-A4-BILLINGSUMMARY3Q-ANI2062929

3.) Start a PivotTable in a new worksheet as follows:

A.) Display the range named ThirdQ and then insert a PivotTable in a new worksheet.

B.) Add the Attorney LName field as rows.

c.) Add the Area field as columns.

D.) Sum the Fees Due field.Due field.

4.) Apply the Pivot Style Medium 2 style to the PivotTable (second column first row in the Medium section)

5.) 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.

6.) Name the worksheet PivotTable and then do the following:

A.) In cell A1, typeAssociate Billing Summary. Change the font to 14-point Copperplate Gothic Bold. Merge and Center the text across the PivotTable.

B.) In cell A2, typeOctober - December 2015. Change the font to 14-point Copperplate Gothic Bold. Merge and center the text across the PivotTable.

C.) Change the orientation to landscape.

7.) Start a PivotChart from the PivotTable using a 3-D Stacked Column chart and move the chart to its own sheet named PivotChart

8.) Apply Style 7 to the PivotChart (seventh style in the Chart Styles Gallery)

9.) Filter the PivotChart by the attorney named Martinez.

Tutorials for this Question
1. ## Solution: CIS 114DE Assessment 4

Tutorial # 00543193 Posted By: Prof.Longines Posted on: 06/14/2017 01:23 AM
Puchased By: 3
Tutorial Preview
The solution of CIS 114DE Assessment 4...
Attachments
EL2-C4-A4-BillingSummary3Q-ALL2070240.xlsx (27.11 KB)
EL2-C4-A4-BillingSummary3Q-ALL2070240.pdf (8.7 KB)
Recent Feedback
Rated By Feedback Comments Rated On
To...9620 100% error-free tutorials 04/25/2020

Great! We have found the solution of this question!