PivotTable Fields Mastery
3 Questions
1 Views

PivotTable Fields Mastery

Created by
@AwestruckCarnelian

Podcast Beta

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Where can you place fields in a PivotTable?

  • Rows, Columns, Values, and Filters (correct)
  • Rows, Columns, Fields, and Sorts
  • Rows, Columns, Values, and Sorts
  • Rows, Columns, Fields, and Filters
  • What is the purpose of dragging field names to the four areas at the bottom of the PivotTable Fields task pane?

  • To define the PivotTable's data structure (correct)
  • To change the PivotTable's formatting
  • To delete fields from the PivotTable
  • To create a new PivotTable
  • How many areas are there at the bottom of the PivotTable Fields task pane?

  • Four (correct)
  • Five
  • Six
  • Three
  • More Like This

    PivotTable Pro
    3 questions
    PivotTable Mastery
    3 questions

    PivotTable Mastery

    AwestruckCarnelian avatar
    AwestruckCarnelian
    PivotTable Mastery
    3 questions

    PivotTable Mastery

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