1. You need to build a PivotTable from a new dataset and place it on a separate sheet. Which setup sequence should you use?
Convert the data to an Excel Table with headers, then choose Insert > PivotTable > From Table/Range > New Worksheet
Explanation
The setup begins by converting the source data to an Excel Table with headers enabled, followed by inserting a PivotTable from that table onto a new worksheet. Creating the pivot first reverses the sequence, Existing Worksheet changes the destination, and omitting headers fails to meet the setup requirement.