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