Podcast
Play an AI-generated podcast conversation about this lesson
Questions and Answers
Which area in the PivotTable Fields pane should you drag the Distribution Center header to in order to reorganize the data?
Which area in the PivotTable Fields pane should you drag the Distribution Center header to in order to reorganize the data?
- Filters area
- Rows area
- Columns area (correct)
- Values area
What happens to the PivotTable when you move the Distribution Center header from Rows area to Columns area?
What happens to the PivotTable when you move the Distribution Center header from Rows area to Columns area?
- The data is sorted alphabetically
- The data is deleted
- The data remains the same
- The data is reorganized (pivoted) (correct)
Which area in the PivotTable Fields pane is not used for reorganizing data in a PivotTable?
Which area in the PivotTable Fields pane is not used for reorganizing data in a PivotTable?
- Columns area
- Filters area
- Rows area
- Values area (correct)
