The worksheet you are viewing is "Sheet1." To set the PivotTable in its own sheet all of the following are true EXCEPT:
A) In the Create PivotTable dialog box,make sure the Select a table or range option button is selected.
B) In the Create PivotTable dialog box,make sure the correct name for the range appears in the Table/Range box.
C) Click the New Worksheet option button.
D) In the Create PivotTable dialog box,a new worksheet,Sheet1,is inserted to the right of the current worksheet.

Question

Quizplus · Accepted Answer

The statement "In the Create PivotTable dialog box,a new worksheet,Sheet1,is inserted to the right of the current worksheet" is false. If you want to set the PivotTable in its own sheet, you need to select the "New Worksheet" option button in the Create PivotTable dialog box, which will create a new sheet for the PivotTable. Therefore, the correct answer is D.

The Worksheet You Are Viewing Is "Sheet1