Question: 6 . Marina also wants to insert a PivotTable that includes other Customer information so that she can analyze Family plan customer data. Return to
Marina also wants to insert a PivotTable that includes other Customer information so that she can analyze Family plan customer data. Return to the Customers worksheet, and then create a PivotTable based on the Customers table as follows:
a Place the PivotTable on a new worksheet, and then use Customers Pivot as the name of the worksheet.
b Display the order location as column headings.
c Display the state field and then the customer field as row headings.
d Display the years as the values.
e Display the plan type as a filter, and then filter the PivotTable to display customer information for Family plans only.
f Hide the field headers to reduce clutter in the PivotTable.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
