PivotTable Mastery

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson
Download our mobile app to listen on the go
Get App

Questions and Answers

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?

  • 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?

  • Columns area
  • Filters area
  • Rows area
  • Values area (correct)

Flashcards are hidden until you start studying

More Like This

PivotTable Pro
3 questions
PivotTable Mastery
3 questions
PivotTable Fields Mastery
3 questions

PivotTable Fields Mastery

AwestruckCarnelian avatar
AwestruckCarnelian
Pivot Table Calculated Fields Quiz
20 questions
Use Quizgecko on...
Browser
Browser