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:

Fixed Manufacturing Overhead Standards

Pre-determined benchmarks for the fixed costs involved in the production process, not varying with the level of output.

Budgeted Fixed Manufacturing Overhead

The estimated fixed costs involved in manufacturing that do not change with the level of production or sales volume.

Standard Cost System

A cost accounting system that assigns fixed costs to products based on predefined standards, facilitating budgeting and variance analysis.

Net Operating Income

The profit a business makes after deducting operating costs, but before removing interest and tax expenses.