USING MICROSOFT EXCEL
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 Analyze > Refresh, or press Alt+F5. Tip: You can also refresh the PivotTable by right-clicking on the PivotTable, and then selecting Refresh. To update all PivotTables in your workbook at once, click Analyze > Refresh arrow > Refresh All.
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.