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 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
Flashcards are hidden until you start studying
