I need help with question 6 given and prepare the worksheet for Excel by the data of customers. Also, please explain or provide the steps of how to do those questions in the new worksheet of Excel. O VIEWInstructions_SC_EX19_8a (2) Protected View Saved to this PCPage 2 of 11Insert Draw Design LayoutReferences Mailings ReviewView HelpBe careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.TION CANCELLED On Sunday, December 25, 2022, most features of Word will be disabled.6.1439 words65°FClear.Text Predictions: On7.a.ReactivateMarina 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:b.C.d.e.Search (Alt+Q)8.Place the PivotTable on a new worksheet, and then use Customers Pivot as thename of the worksheet.Display 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 Pivotlable 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.Shelly Cashman Excel 2019 | Module 8: SAM Project laEnable Editinga.CENGAGEInsert a Sunburst chart to display the hierarchies for Marina as follows:Insert a Sunburst chart based on the mobile device order data in the rangeG4:315.b.Resize and position the chart so that it covers the range G16:K34.C.Use Mobile Device Orders as the chart title.Go to the Customers by Plan worksheet, which contains a Pivot Table showing theFocusDAJeffrey WangCo File Home Insert Draw Page Layout Formulas DataPivot Table Recommended TablePivot TablesA43456789101112131415Add-insi SUBSCRIPTION CANCELLED On Sunday, December 25, 2022, most features of Excel will be disabled.Customer-501050155019502050235025502750295031503350375039161718192021222324nrTables4ReadyLADAY51025104510651085110511265°FClearBYears42135647231132466Illustrations54Customer351145116PLAD... PlansAccessibility: InvestigateCStateDCNCDEDCNCMDDCVADEVADEVAMDDCNCGet Add-insDMy Add-insVIN1UN3UN2BA3FA2S11UN3UN2FA3FA2BA3UN1FUDCVAMDDCVAPayments by State Pivot Sheet2E15Plan IDBA2FA2FA3UN2FA1 FamilyS11UN2FA3Mobile Phone Customers# of Lines# of LinesPlanPlan TypeTypeReview Viewb?RecommendedChartsBasicFamilyFamilyUnlimitedSingleUnlimitedFamilyInternationalUnlimitedUnlimitedBasicFamilySingleUnlimitedUnlimitedFamilyFamilyBasicUnlimitedCustomersFQ236221261524311526341OrdersHelpDE-A-dhXXVVTable DesignV-ChartsGReactivateOrder LocationOnlineOnlineEM storeOnlinePhone storeOnlinePhone storeOnlineEM storeOnlineOnlineOnlineEM storePhone storeOnlineOnlineEM storeMaps PivotChart-HPayment$60.00$120.00$240.00$130.00$80.00$45.00$130.00$240.00$60.00$325.00$130.00√de ţ felle pooLine Column Win/LossTours$120.00$120.00$45.00$325.00$130.00$240.00Phone store$120.00Phone storeOnlineCustomers by Plan Sales Pivot Location Pivot$120.00$65.00enn anJ+SparklinesKarSlicer TimelineLFiltersHIMLinkLinksNCommenComments01211

Question

Accepted Answer

Note: - As it is specified to answer question 6, we will answer it with all subparts. If an answer…