Podcast
Play an AI-generated podcast conversation about this lesson
Questions and Answers
Which of the following best describes why you might want to change the name of a PivotTable?
Which of the following best describes why you might want to change the name of a PivotTable?
- To make it more difficult to use the PivotTable data in a formula on another worksheet
- To make it easier to understand the data it contains (correct)
- To make it more difficult to understand the data it contains
- To confuse your colleagues
What determines the best way to summarize the data in the column you assign to the Values area in a PivotTable?
What determines the best way to summarize the data in the column you assign to the Values area in a PivotTable?
- Excel (correct)
- The data in the column
- The user
- The PivotTable Fields pane
What can you do to control which totals and subtotals appear in a PivotTable?
What can you do to control which totals and subtotals appear in a PivotTable?
- You can't control which totals and subtotals appear in a PivotTable
- You can control which totals and subtotals appear, and where they appear, to best suit your data and analysis goals (correct)
- You can only control which totals appear in a PivotTable
- You can only control where the totals and subtotals appear in a PivotTable
Which of the following is a reason to change the name of a PivotTable?
Which of the following is a reason to change the name of a PivotTable?
Signup and view all the answers
What determines the function used to summarize data in the Values area of a PivotTable?
What determines the function used to summarize data in the Values area of a PivotTable?
Signup and view all the answers
What can you do to control which totals and subtotals appear in a PivotTable?
What can you do to control which totals and subtotals appear in a PivotTable?
Signup and view all the answers
