Excel PivotTable Renaming Quiz

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

Excel (correct)

The data in the column

The user

The PivotTable Fields pane

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

<p>To make it easier to understand the data it contains</p> Signup and view all the answers

<p>Excel</p> Signup and view all the answers

<p>Choose which fields to include in the Rows and Columns areas</p> Signup and view all the answers