Question

How can a user remove or delete a PivotTable?

Answer 1

Answer:

Explanation:

If you get a "Cannot change this part of a PivotTable report" message, make sure the entire PivotTable is selected. Press Ctrl+A, and press Delete again.

If you're using a device that doesn't have a keyboard, try removing the PivotTable like this:

Pick a cell anywhere in the PivotTable to show the PivotTable Tools on the ribbon.

Select Entire PivotTable

Click Analyze > Select, and then pick Entire PivotTable.

Press Delete.

Hope this will help you

Answer 2

Answer:

D) All of the options described are correct

Explanation:

-Select the PivotTable and click Clear All in the Actions group under the Options tab on the PivotTable Tools contextual tab.

-Delete the worksheet that contains the PivotTable.

-Select the columns and/or rows containing the PivotTable, and press Delete on the keyboard.