DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
You must close your workbook and re-open it to get the Pivot Table to update
|
|
|
The Pivot Table will update automatically
|
|
|
You must manually refresh your Pivot Table in order to see the change show up there
|
|
|
Don’t know
|
Detailed explanation-1: -What are the implications? The pivot table should be refreshed manually to see the changes The workbook must be closed and reopened to see the changes The changes will reflect automatically O Excel crashes Question 6 10 pts On a Pivot Table, what do we call a field with.
Detailed explanation-2: -Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon. Click Analyze > Refresh, or press Alt+F5. Tip: You can also refresh the PivotTable by right-clicking on the PivotTable, and then selecting Refresh.
Detailed explanation-3: -An Excel pivot chart layout is tied to the layout of the pivot table it’s connected to. If you change the pivot chart layout, the pivot table will also change, and vice versa.
Detailed explanation-4: -No, this isn’t automatic, but a quick and easy way to refresh the pivot table after the data changes is to manually update it: Right-click any cell in the pivot table, then click on Refresh.