PivotTable Mastery
3 Questions
2 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

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?

  • 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)
  • More Like This

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

    PivotTable Fields Mastery

    AwestruckCarnelian avatar
    AwestruckCarnelian
    PivotTable Filtering Mastery
    3 questions

    PivotTable Filtering Mastery

    TrustworthyCarnelian avatar
    TrustworthyCarnelian
    Use Quizgecko on...
    Browser
    Browser