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

When you add a filter to a pivot chart, how do you update the data in the original source pivot table?1 pointYou need to refresh the pivot table worksheet to refresh the data You need to manually add the filter to the pivot table in the PivotTable Fields pane You need to click Refresh All in the Data group of the Analyze tab for the pivot table You do not need to do anything, as changes are immediately reflected in the pivot table data too

A pivot chart differs from a regular chart insofar that:a pivot chart can filter the data directly within the chart,a pivot chart contains more data than a regular chart cana pivot chart must categorize the information from largest to smallesta regular chart is easier to build

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.

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

Which of the followings is FALSE?Group of answer choicesPivot Chart uses data from Pivot TableYou can not change the chart type in Pivot ChartChanges in Pivot Table will change Pivot ChartIf you change filter option in Pivot Chart, filter option in Pivot Table will change.