Session 5.3

¡Supera tus tareas y exámenes ahora con Quizwiz!

Layout area for a Pivot Table: Report filter

A field used to filter the report by selecting one of more items, enabling you to display a subset of data in a Pivot Table report

Fields in the report filter area create

A filtered view of the Pivot Table, showing summarized data in the report

A Pivot Chart

A graphical representation of the data in a pivot table

A PivotTable is

An interactive table used to group and summarize either a range of data or an excel table into a concise, tabular format for easier reporting and analysis

A slicer is

An object used to filter a Pivot Table or Pivot Chart. You can create more than one slicer for a Pivot Table or Pivot Chart

The Pivot Table uses the data from the Category field as

Column labels

Category fields are the fields that

Group the values in a Pivot Table, such as condition. location, and year acquired

Values fields

The fields that contain summary data in a Pivot Table. This Pivot Table uses the total of the Appraised Value as the values fields (tutorial 5.3)

Category fields are

The fields that group the values in a Pivot Table. Category fields appear in Pivot Tables as row labels, column labels, and report filters

Layout area for a Pivot Table: Column labels

The fields you want to display as columns at the top of the Pivot Table. One column is displayed for each unique item in this area. You can have nested column fields

Layout area for a Pivot Table: Row labels

The fields you want to display as the rows in the Pivot Table. One row is displayed for each unique item in this area. You can have nested row fields

Layout area for a Pivot Table: Values

The fields you want to summarize

The Pivot Chart Tools contextual tabs enable you to

Manipulate and format the selected PivotChart the same way as an ordinary chart

Compact report layout

Places all fields from the row area in a single column and indents the items from each field below the outer fields.

You can add many levels of

Subtotals and totals to a Pivot Table

Fields in the Values area are

Summarized in the Pivot Table

Fields that contain summary data are called

Value fields

Collapse button indicates

You can hide details for that item

The expand button indicates

You can show more details for that item

This Pivot Tables uses the data from the

Location field as row labels

Fields in the column labels area are

Displayed as columns at the top of the Pivot Table

Fields in the row levels area are

Displayed as rows in the Pivot Table

Filtering a field lets you

Focus on a subset of items in that field

A Pivot Chart allows you to

Interactively add, remove, filter and refresh data fields in the Pivot Chart similar to working with a Pivot Table.


Conjuntos de estudio relacionados

Key Terms Chapter 3 - Statistics

View Set

Pharmacology II - RN Pharmacology Online Practice 2019 A

View Set

GA Personal Lines Guarantee Exam Attempt #1

View Set

Unit 1 exam EAQ practice questions

View Set

Grupo 17 Diptongos oi,oy, ui, uy

View Set