Excel in 30 Minutes Advanced PivotTables and Slicers

If you need a new data point in a PivotTable, you can use a Calculated Field to do this.

True

False

In the PivotChart Fields pane, the Axis is similar to the __________ in the PivotTable Fields pane.

Column

Row

Legend

Filter

Why would you want to insert a Slicer with a PivotTable? Select the correct answer and click Submit.

Use slicers when you want to see the general direction of data

Use slicers when you want to show trends in a series of values

Use slicers when you don"t want to see the entire Pivot Table, just part of it

Information