Podcast
Questions and Answers
Which area in Excel affects how data is organized in a PivotTable?
Which area in Excel affects how data is organized in a PivotTable?
- Values
- Filters
- Rows and Columns (correct)
- Charts
What is an example of how the order of fields affects PivotTable organization?
What is an example of how the order of fields affects PivotTable organization?
- Grouping PivotTable columns by category and then by supplier
- Grouping PivotTable rows by month and then by distribution center (correct)
- Grouping PivotTable columns by year and then by region
- Grouping PivotTable rows by product and then by salesperson
Which area in Excel allows you to filter data in a PivotTable?
Which area in Excel allows you to filter data in a PivotTable?
- Rows and Columns
- Charts
- Values
- Filters (correct)