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
Computer Science & Information Technology
You might also like to view...
To remotely connect to a workplace, you would set up a virtual private network (VPN)
Indicate whether the statement is true or false
Computer Science & Information Technology
Microsoft Office provides utilities for saving files in an encrypted format.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology