I need help with question 6 on how to create the customer pivot table as given. Also, can you provide the steps of how to do that in Excel? Also, please provide the steps in order to solve the problem for Finance. Design Layout ReferencesMailings Review View Helpcareful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.6.Draw7.Text Predictions: On65VAMDEnable EditingMarina also wants to insert a PivotTable that includes other Customer information sothat 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.b.C.d.e.Place the PivotTable on a new worksheet, and then use Customers Pivot as thename of the worksheet.IDisplay the order location as column headings.Display the state field and then the customer field as row headings.Display the years as the values.Display the plan type as a filter, and then filter the PivotTable to display customerinformation for Family plans only.f.Hide the field headers to reduce clutter in the Pivot Table.Go to the Orders worksheet. The Order_Summary table in the range G4:J15 shows thesales for three categories of mobile device orders, with each category divided into typesand then into models. Marina wants to display these hierarchies of information in achart.FA3FA2FamilyFamily63CENGAGEEM storePhone storeComments$240.00Focus80 File29.eUndoA43AutoSave4567891011121314Home15161718192021Paste2223242526ClipboardCustomer5010501550195020502350255027Off A SC EX19_8a JeffreyWang 2Insert Draw Page Layout FormulasXLB-S50295031Ready503350374 ▸vix ✓ fx Customer50395102510451065108511051125114511651185120@68°FSunnyTrebuchet MSBBIUYears4213564723112466543Accessibility: Investigate#C3FontFF -DCNCDCVA2DC5MDPayments by State PivotVAMDDCState Plan IDDCNCDEDCNCMDDCVADEVADEVAMD11$* Α' Α'A A4BAZFA2FA3UN2FA1S11UN2FA3IN1UN3UN2A-BA3FA2511UN3UN2FA3FA2BA3UN1FA1FAZvDEMobile Phone CustomersData ReviewFamilyFamilyUnlimited===FamilySingleUnlimitedFamilyInternationalUnlimitedUnlimitedBasicFamilySinglePlan Type # of Lines-Basic2362UnlimitedUnlimitedFamilyFamilyBasicdo365View HelpFY6Alignment21261524315263412Help Table Design32Wrap TextOnlineUnlimitedFamilyFamilyOnlineCustomers pivot Customers Orders Customers by PlanO Search (Alt+Q)Merge & Center"4+Order LocationOnlineOnlineEM storeOnlinePhone storeOnlinePhone storeOnlineEM storeOnlineOnlineOnlineEM storePhone storeOnlineOnlineEM storePhone storePhone storeOnline&G7*45General-$%95800nHNumberPayment$60.00$120.00$240.00$130.00$80.00$45.00$130.00$240.00$60.00$325.00$130.00$120.00$120.00$45.00$325.00$130.00$240.00$120.00$120.00$65.00$80.00$120.00Sales Pivot.hpJLocation Pivotno DAIINConditional Format as CellTable StylesFormatting -StylesK+ 1*** --na ofLLagInsert Delete FormatMbrt scCellsNJeffrey Wang JWOEMvV28OSort & Find &Filter Select "EditingdeletePBQhomeComments(d)PEAnalyzeDataAnalysisRdendF---Templaofficeatw10/1

Question

I need help with question 6 on how to create the customer pivot table as given. Also, can you provide the steps of how to do that in Excel? Also, please provide the steps in order to solve the problem for Finance. Design Layout ReferencesMailings Review View Helpcareful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.6.Draw7.Text Predictions: On65VAMDEnable EditingMarina also wants to insert a PivotTable that includes other Customer information sothat 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.b.C.d.e.Place the PivotTable on a new worksheet, and then use Customers Pivot as thename of the worksheet.IDisplay the order location as column headings.Display the state field and then the customer field as row headings.Display the years as the values.Display the plan type as a filter, and then filter the PivotTable to display customerinformation for Family plans only.f.Hide the field headers to reduce clutter in the Pivot Table.Go to the Orders worksheet. The Order_Summary table in the range G4:J15 shows thesales for three categories of mobile device orders, with each category divided into typesand then into models. Marina wants to display these hierarchies of information in achart.FA3FA2FamilyFamily63CENGAGEEM storePhone storeComments$240.00Focus80 File29.eUndoA43AutoSave4567891011121314Home15161718192021Paste2223242526ClipboardCustomer5010501550195020502350255027Off A SC EX19_8a JeffreyWang 2Insert Draw Page Layout FormulasXLB-S50295031Ready503350374 ▸vix ✓ fx Customer50395102510451065108511051125114511651185120@68°FSunnyTrebuchet MSBBIUYears4213564723112466543Accessibility: Investigate#C3FontFF -DCNCDCVA2DC5MDPayments by State PivotVAMDDCState Plan IDDCNCDEDCNCMDDCVADEVADEVAMD11$* Α' Α'A A4BAZFA2FA3UN2FA1S11UN2FA3IN1UN3UN2A-BA3FA2511UN3UN2FA3FA2BA3UN1FA1FAZvDEMobile Phone CustomersData ReviewFamilyFamilyUnlimited===FamilySingleUnlimitedFamilyInternationalUnlimitedUnlimitedBasicFamilySinglePlan Type # of Lines-Basic2362UnlimitedUnlimitedFamilyFamilyBasicdo365View HelpFY6Alignment21261524315263412Help Table Design32Wrap TextOnlineUnlimitedFamilyFamilyOnlineCustomers pivot Customers Orders Customers by PlanO Search (Alt+Q)Merge & Center&#34;4+Order LocationOnlineOnlineEM storeOnlinePhone storeOnlinePhone storeOnlineEM storeOnlineOnlineOnlineEM storePhone storeOnlineOnlineEM storePhone storePhone storeOnline&G7*45General-$%95800nHNumberPayment$60.00$120.00$240.00$130.00$80.00$45.00$130.00$240.00$60.00$325.00$130.00$120.00$120.00$45.00$325.00$130.00$240.00$120.00$120.00$65.00$80.00$120.00Sales Pivot.hpJLocation Pivotno DAIINConditional Format as CellTable StylesFormatting -StylesK+ 1*** --na ofLLagInsert Delete FormatMbrt scCellsNJeffrey Wang JWOEMvV28OSort & Find &Filter Select &#34;EditingdeletePBQhomeComments(d)PEAnalyzeDataAnalysisRdendF---Templaofficeatw10/1

Accepted Answer

A pivot table is a standard tool for data summary in spreadsheet programs like Microsoft Excel or…