You can a PivotTable by using a search filter or by using sl

You can a PivotTable by using a search filter or by using slicers to limit the data displayed. Match the following PivotTable screen elements with their description FILTERS area COLUMNS area ROWS area VALUES area PivotTable Fields pane A window that lists at the top, all of the fields and column title. An area to position fields that you want to display as columns in the Pivot Table. An area in the lower portion of the PivotTable Fields pane to position fields. The data is grouped by these row titles. Microsoft Access, each row is called a relationship field record primary key A list or table used to create a PivotTable or PivotChart report that comes from an Excel list or external databases is called

Solution

1. You can extract a specified portion of a pivot table byusing a search filter or by using slicers to limit the data displayed.

2.

I - E

II - B

III - C

IV - D

V - A

3. In Microsoft Access, rows are called records and columns are called fields.

4. A list or table used to create Pivot table or Pivot Chart report that comes from an Excel list or external database is called data source if the table is in the current excel sheet, or it is called external data source if the data is from any external source.