An Area to Position Fields That Contain Data That Is

question 45

Multiple Choice

An area to position fields that contain data that is summarized in a PivotTable or PivotChart is called the ________.

• A)COLUMNS area
• B)ROWS area
• C)VALUES area
• D)FILTER area

---

Definitions:

Compounded Monthly

The process of adding interest to the principal sum of a loan or deposit, where the amount of the interest is calculated monthly and then added to the sum, causing interest on interest.

Compounded Semi-Annually

The process of applying interest to an initial amount and to the accumulated interest over two periods within a year.

EAR

Effective Annual Rate, which measures the real return on an investment or the real interest rate on a loan, accounting for the effect of compounding.