DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How do you remove or delete a Pivot Table?
|
|
Select the Pivot Table and press Clear All in the Actions group under the Options tab on the PivotTable Tools contextual tabs.
|
|
|
Delete the worksheet that contains the Pivot Table.
|
|
|
Select the columns and/or rows containing the Pivot Table and press Delete on your keyboard.
|
|
|
All of the options listed above are correct.
|
Explanation:
Detailed explanation-1: -Click the PivotTable. On the Options tab, in the Actions group, click Clear, and then click Clear All.
Detailed explanation-2: -How do you remove or delete a Pivot Table? Select the Pivot Table and press Clear All in the Actions group under the Options tab on the PivotTable Tools contextual tabs.
There is 1 question to complete.