You Created a PivotTable and Later Made Changes to Values

question 54

Multiple Choice

You created a PivotTable and later made changes to values in the underlying data.What happens to the PivotTable?

• A)The PivotTable updates automatically when you make changes to the dataset.
• B)Excel gives an error message that data has changed and the PivotTable may no longer be accurate.
• C)Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.
• D)Excel deletes the PivotTable automatically so you can recreate it.

---

Definitions:

Symbolic Interactionism

A viewpoint in sociology that emphasizes how people understand and assign significance to social symbols, interactions, and occurrences.

Macro Level

A broad perspective in sociology and other disciplines that analyses the social systems, structures, and processes at a large scale, focusing on the overall social dynamics rather than individual actors.

Micro Level

Analysis or perspective focusing on small-scale interactions or individual aspects of larger phenomena, often in contrast to macro-level analyses.

Self and Society

The exploration of how individuals relate to, identify with, and understand their place within society.