When the Source Data Used to Create an Excel Pivottable

question 26

Multiple Choice

When the source data used to create an Excel pivottable change, the pivottable will update __________.

• A) automatically
• B) only after the file is saved
• C) only when the pivottable is "refreshed"
• D) never, any change requires a new pivottable

---

Definitions:

Equilibrium

A state of balance or stability within a system, achieved when opposing forces or influences are equal.

Positional Power

The authority and influence bestowed upon individuals because of their rank or position within an organization, enabling them to exert control over others.

Monetary Rewards

Financial incentives given as recognition for an individual's or group's achievements, serving as motivation for continued performance or behavior.

Financial Performance

A measure of how well a firm uses assets from its primary mode of business and generates revenues.