In a PivotTable, When a Field Is Dragged to the Values

question 14

Multiple Choice

In a PivotTable, when a field is dragged to the Values section below the PivotTable Field List, the default value setting is ____.

• A) Average
• B) Count
• C) Max
• D) Sum

---

Definitions:

Par Value

The face value of a bond or the stock value stated in the corporate charter, which may differ from its market value.

Carrying Value

The book value of an asset on a company's balance sheet, calculated as the original cost minus accumulated depreciation.

Loss On Redemption

The financial loss incurred when a debt instrument, such as a bond, is repaid before its maturity date.

Effective-Interest Method

A method of calculating the amortized cost of a bond and the amount of interest expense over its relevant period.