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:

Face Value

The original value of a financial instrument as indicated on the certificate or instrument itself, equivalent to its par value.

Market

A venue or medium where buyers and sellers come together to exchange goods, services, or financial instruments.

Coupon Rate

The percentage annually paid as interest on a bond, relative to its face value.

Market Interest Rate

The prevailing rate of interest determined by supply and demand in the money market.