You created a PivotTable and later made changes to values in the underlying data. What happens to the PivotTable?
A) Excel gives an error message that data has changed and the PivotTable may no longer be accurate.
B) Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.
C) The PivotTable updates automatically when you make changes to the dataset.
D) Excel deletes the PivotTable automatically so you can recreate it.
B
You might also like to view...
When Hyper-V loads for the first time, it creates the parent _______________.
Fill in the blank(s) with the appropriate word(s).
To change a selected shape's height or width to a specific value, type the value in the Height or Width text boxes on the ____ tab.
A. Format B. Image C. Measurements D. Graphic
Name the three classes of Bluetooth and their maximum distances.
What will be an ideal response?
A(n) ________ rule limits the values that can be entered in a field.
Fill in the blank(s) with the appropriate word(s).