Match the Following PivotTable Screen Elements with Their Description

question 87

Multiple Choice

Match the following PivotTable screen elements with their description:
i.FILTERS area
II.COLUMNS area
III.ROWS area
IV.VALUES area
v.PivotTable Fields pane

• A)A window that lists at the top,all of the fields and column titles.
• B)An area to position fields that you want to display as columns in the PivotTable.
• C)An area in the lower portion of the PivotTable Fields pane to position fields.
• D)Numeric of financial in nature and the data is summarized.
• E)The data is grouped by theses row titles.

---

Definitions:

Construction Loans

Short-term loans used to finance the building of a property, with funds released incrementally as construction progresses.

Mortgage Trust

A type of investment trust that pools mortgage loans, offering investors a share in the income generated from these mortgages.

REIT

Real estate investment trust, which is similar to a closed-end mutual fund. REITs invest in real estate or loans secured by real estate and issue shares in such investments.

Front-end Load

A fee or commission charged to an investor at the time of initial purchase of an investment, such as a mutual fund or insurance product, usually a percentage of the investment amount.