FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Suppose you create a PivotTable and then make changes to the source data for that PivotTable, and notice that the changes are not showing up.What do you need to do?
A
Go to Analyse > Refresh to update the PivotTable
B
Go to Data > initialize to update the PivotTable
C
delete the PivotTable, then generate a new one
D
Save the workbook to update the PivotTable
Explanation: 

Detailed explanation-1: -If you make changes to the source data a PivotTable is based on, the PivotTable isn’t automatically updated. Instead, you must manually refresh the PivotTable anytime you change its underlying source data.

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: -Changes that you make to the layout and data in an associated PivotTable are immediately reflected in the layout and data in the PivotChart and vice versa.

Detailed explanation-4: -Since your Pivot Table is created using the Pivot Cache, when the existing data changes or when you add new rows/columns to the data, the Pivot Cache does not update itself automatically, and hence, the Pivot Table also does not update. You need to force a refresh every time there are changes.

There is 1 question to complete.
Previous
Next