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:

Interest Rate Parity

A theory stating that the difference in interest rates between two countries is equal to the expected change in exchange rates between their currencies.

Canadian T-Bills

Short-term government securities issued by the Canadian government, considered low-risk investments.

Egyptian Pounds

The official currency of Egypt, denoted as EGP, and divided into smaller units called piastres.

Exchange Rates

The value of one currency for the purpose of conversion to another, indicating how much one currency is worth in terms of another.