Juanita Lists Expenses in a PivotTable Field Named Expenses

question 91

Multiple Choice

Juanita lists expenses in a PivotTable field named Expenses. She wants to filter the PivotTable to display data only for expenses greater than $1,000. What type of filter should she use?

• A) Manual
• B) Date
• C) Label
• D) Value

---

Definitions:

Nominal Rate

The stated interest rate on a loan or investment, not adjusting for inflation or compounding effect.

Inflation

Inflation refers to the pace at which the average cost of products and services increases, leading to a decrease in buying power.

Zero-Coupon Bonds

Zero-coupon bonds are a type of bond that does not pay interest during its life and is instead sold at a discount to its face value, with the full face value being repaid at maturity.

Yield

Yield refers to the earnings generated and realized on an investment over a particular period, expressed as a percentage based on the investment's cost, current market value, or face value.