Filters can be used to limit the fields that are displayed, sort on particular fields, and calculate new

Match the following PivotTable areas with the corresponding description:

I. PivotTable Fields task pane II. Filters Area III. Columns Area IV. Rows Area V. Values Area A. Organizes and groups data into categories on the left side. Each group name occupies a single row. B. Displays summary statistics, such as totals or averages. C. Subdivides data into one or more additional categories. D. Filters the data to display results based on particular conditions you set. E. Contains two sections that allow for the editing of a PivotTable.

Video content will be identified as _________ format.

A. GIF B. MPEG C. BMP D. JPEG