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:

Background Color

The color that appears behind the content of a webpage, document, or application interface.

Conditional Formatter

A feature in spreadsheet and database software that changes the appearance of cells based on certain conditions.

Format Painter

A tool in many software applications that lets users copy formatting from one item to another.

Shape Effects Tool

A feature in graphic design and presentation software that allows users to apply special visual effects to shapes, such as shadows, glows, and bevels.