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:

Parent Entity

A company that holds a controlling interest in another company, giving it control of its operations and policies.

Subsidiary

A company that is completely or partly owned and partly or wholly controlled by another company, known as the parent company.

Unrealised Profits

Profits that have been reported but not yet realized through cash or other payments.

Consolidation Adjustments

Adjustments made to a parent company's financial statements to eliminate the effects of intercompany transactions when consolidating subsidiaries.