The Worksheet You Are Viewing Is "Sheet1

Multiple Choice

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.