Using the same Pivot Table as you did in Question 1, select Show Report Filter Pages. Which of the following is true?1 pointTwo new worksheets with new Pivot Tables have been added, one showing data for Home Office and one for Small Business.A new worksheet with new Pivot Tables has been added for each of the Customer Types.A new worksheet with new Pivot Tables has been added for each of the Account Managers.

Uma can remember that when you create a Pivot Chart the Field filters appear on the Pivot Chart. Sean has just walked in talking about how useful Report Filters are. Uma now cannot recall if Report Filters also appear on the Pivot Chart. Do they? (Hop over to Excel and create a chart for a table that contains a report filter if you are confused as well).

Which of the following can be created from a PivotTable? 1. PivotFilters 2. PivotCharts 3. PivotFormats 4. PivotFills

Which is NOT true about pivot table?Question 1Select one:a.It allows a static view of your data.b.The data should be organised as stacked data.c.You can manipulate various ways to see data summary.d.You can change the summary functions.

Which of the following is not in the Pivot table field list box?Select one:A.ValuesB.FormulasC.Report filterD.None of these

Which of the following Microsoft Excel tool can be used to filter datasets and create more focused reports by putting slicers next to important visuals?Pivot TableMacrosSlicers