Tutorial 5

Total row

A row at the end of an Excel table that is used to calculate summary statistics (such as sum, average, count, maximum, and minimum) for each column in the Excel table

pane

A section of a window; In Excel, you can split the worksheet window into two or four resizable panes

field

A single piece of data that describes a characteristic of a person, place, or thing (such as a last name, a city, or a project); each column in an Excel table or structured range of data represents a field

slicer

An object used to filter an Excel table, a PivotTable, or a PivotChart

PivotTable

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

worksheet group

A ___ ___ is a collection of two or more selected worksheets.

3-D reference

A ___ ___ is a reference to the same cell or range in multiple worksheets in the same workbook.

field name, column header

A ___ ___, or ___ ___, is a unique label that describes the contents of the data in a column.

slicer

A ___ is an object used to filter a PIvotTable or PivotChart.

split bar

A moveable bar that indicates the division between panes and that can be dragged to resize the panes

table name

Every Excel table has a _____ ______, which you can change to a descriptive name

Criteria filter

Criteria filter___ ___ enable you to specify various conditions in addition to those that are based on an "equals" criterion.

filter arrow

The ___ ___ changes to a sort icon as a reminder that the data is sorted by that field.

ascending order

The arrangement of text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest

descending order

The arrangement of text in reverse alphabetical order from Z to A, numbers from largest to smallest, and dates from newest to oldest

sort fields

The fields that you use to order data are called ___ ___.

header row

The first row of the range contains field names called the ____ ____.

header Row

The first row of the range contains field names called the ________.

header row

The first row of the range or Excel table that contains field names

primary sort field

The first sort field

secondary sort field

The second sort field

custom list

The sequence you specify to sort data

sort

You can rearrange or _____ the records in a table or range based on one or more fields

sort

You can rearrange, or ____, the records in a table or range based on one or more fields.

refresh

To update

Data definition table

___ ___ ___ is documentation that lists the fields to be maintained for each record.

Category fields

___ ___ are the fields that group the values in a PivotTable.

Ascending order

___ ___ arranges text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest.

Descending order

___ ___ arranges text in reverse alphabetical order from Z to A, numbers from largest to smallest, and dates from newest to oldest.

Table style

___ ___ provide a way to quickly format an entire table using a preset style definition.

calculated field

a formula you define to generate PivotTable values that otherwise would not appear in the PivotTable.

refresh

after you edit the underlying data you must update, the PivotTable report to reflect the revised calculations

pivot table

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

slicer

an object used to filter a pivottable or pivotchart. you can create more than one

ascending order

arranges text alphabetically from A to Z, numbers smallest to largest, and dates from oldest to newest

ascending order

arranges text alphabetically from a to z, numbers from smallest to largest, and dates from oldest to newest.

descending order

arranges text in reverse alphabetical order from Z to A, numbers from largest to smallest, and dates from newest to oldest.

descending order

arranges text in reverse alphabetical order from z to a, numbers from largest to smallest, and dates from newest to oldest.

clear

when you want to redisplay all of the data in a filtered table you need to ___ the filters

criteria filters

you can specify various conditions in addition to those that are based on an equals criterion.

A ___ ___ indicates the sequence in which you want data ordered.

custom list

selection list

displays the unique items in the selected column

data definition table

documentation that lists the fields to be maintained for each record and a description of the information each field will include.

freezing

lets you keep headings visible as you work with the data in a large worksheet.

data definition table

lists the fields to be maintained for each record, a description of the information each field will include, and the type of data (such as numbers, text, or dates) stored in each field.

The first sort field is called the ___ ___ ___.

primary sort field

table styles

provide a way to quickly format an entire table using a preset style definition

excel table

range of related data that is managed independently from data in other rows and columns in the worksheet

clear

remove the filters, however, when you clear a filter from a column, any other filters are still applied.

The ___ ___ displays the unique items in the selected column.

selection list

The ___ ___ indicates the division between the panes.

split bar

Sort Fields

the fields that you use to order data are called_______

primary sort field

the first sort field

Filtering

the process of displaying a subset of rows in an excel table that meets the criteria you specify

secondary sort field

the second sort field

pane

to view different areas of a large worksheet, you can split the window into two or four resizable areas. each area is called a _______-

Value field

A field that contains summary data in a PivotTable

Category field

A field that groups the values in a PivotTable; appears in a PivotTable as a row label, a column label, and a report filter

sort field

A field that you use to order data

record

A group of related fields; each row in an Excel table or structured range of data represents a record

record

Each row represents a ____, which is a collection of related fields that are grouped together.

record

Each row represents a ______ which is a collection of related fields that are grouped together

The filter arrow opens the ___ ___, which includes options to sort and filter the table based on the data in that column.

Filter menu

___ is the process of displaying a subset of rows in an Excel table that meets the criteria you specify.

Filtering

bold

The name of the active sheet in the worksheet group is ___.

filter

The process of displaying a subset of rows in an Excel table or structured range of data that meets the specified criteria

freeze

The process of keeping rows and/or columns you select visible as you scroll the worksheet

sort

The process of rearranging data such as the records in an Excel table or range based on one or more fields; data can be sorted in ascending or descending order

___ ___ are the fields that contain summary data in a PivotTable.

Values fields

field

each column represents a _______ which describes some characteristic of a person, place, or thing such as a last name, address, city, or state.

criteria filters

enable you to specify various conditions in addition to those that are based on an equals criterion

status bar

indicates that the table is filtered

split bar

indicates the division between the panes

custom list

indicates the sequence in which you want data ordered

custom list

indicates the sequence in which you want data ordered.

Field Name/ or Column Header

is a unique label that describes the contents of the data in a column

total row

is used to calculate summary statistics for any column in an excel table

freezing

keep the headers visible as you work with the data in a large worksheet

filter arrow

opens a filter menu which includes options to sort and filter the table based on the data in the column

PivotChart

A graphical representation of the data in a PivotTable

Table style

A preset style used to quickly format an entire table

Excel table

A range of related data that is managed independently from other data in the worksheet

field name

A unique label that describes the contents of the data in a column; also called a column header

column header

A unique label that describes the contents of the data in a column; also called a field name

adjacent, nonadjacent

A worksheet group can contain ___ or ___ worksheets.

Excel table

An ___ ___ is a range of related data that is managed independently from data in other rows and columns in the worksheet.

criteria filter

Conditions you specify for a filter

data definition table

Documentation that lists the fields to be maintained for each record, a description of the information each field will include, and the type of data stored in each field

field

Each column represents a _____, which describes some characteristic of a person, place, or thing such as a last name, address, city, or state.

A ___ is a graphical representation of the data in a PivotTable.

PivotChart

A ___ 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.

PivotTable

clear

To remove, such as a filter

The ___ ___ is used to calculate summary statistics for any column in an Excel table.

Total row

group-editing

When worksheets are grouped, the workbook is in ___ mode and "[Group]" appears in the title bar.

filter arrow

You can click a ___ ___ to sort the table by data in that column.

Field List

You can create a PivotTable using the ___ ___.

custom list

You can create a ___ ___ to sort data in the order you specify.

Filter Arrow

changes to a sort icon as a reminder that the data is sorted by that field