Excel tutorial 5

Every excel table has a ______, which you can change to a descriptive name.

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

The first row of the range contains field names called the _______. Although the header row often is row 1, it can begin in any row.

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

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

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

The filter arrow changes to a _______ as a reminder that the data is sorted by that field

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

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

The fields that you use to order data are called ____ _____.

To return to cell A1 you press

_____ a row or column lets you keep headings visible as you work with the data in a large worksheet

To delete a record

To sort data

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

Excel provides ____ predefined custom sort lists

_____ ___ to hide or display the total row

The ___ ____ is used to calculate summary statistics (including sum, average, count maximum, and minimum) for any column or excel table

The _____ ___ indicates that the table is filtered

The ____ ____ indicates the division between the panes. You can drag it to ___ the panes

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

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

To view different areas of a large worksheet, you can split the window into two our four resizable areas. Each area is called a _____

You can use options on the _____ menu to create three types of filters

You can filter a column of data by its

After you filter a column, the ____ ____ command becomes available so you can remove the filter and re-display all the records.

row numbers of the _____ ______ are blue

___ ___ indicates the number of records displayed

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

When you click in each cell in the Total Row, an arrow appears that you can click to open a list of

You can summarize data in a range by

The Subtotal command offers many kinds of summary information, including:

The Subtotal command inserts a subtotal row into the ____ for each group of data and adds a ___ __ __ below the last row of data

The subtotal command cannot be used in an excel table, so you must first

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

_____ ____ are the fields that contains summary data in a PivotTable. This PivotTable uses the total of the Appraised Value as the values field

A ________ is a graphical representation if the data in a PivotTable.

A ____ is an object used to filter a PivotTable or PivotChart

You create a PivotTable using the ______ ____.

You click one or more slicer buttons ____ _____ the PivotTable

______ _____ are the fields that group the values in a PivotTable. Such as condition, location, and year acquired.

Category fields appear in PivotTables as _____, ______, and _______

Fields in the _____ ____ area create a filtered view of the PivotTable, showing summarized data in the report. This is a field used to filter the report by selecting one or more items, enabling you to display a subset of data in a PivotTable report.

Fields in the ___ ___ area are displayed as rows in the PivotTable. One row is displayed for each unique item in this area. You have nested row fields.

Fields in the _____ _____ area are displayed as columns at the top of the PivotTable. One column is displayed for each unique item in this area. You have nested column fields.

Fields in the ______ area are summarized in the PivotTable. Field that contains summary data.

How do you get to the PivotTable button?

By default, the PivotTable report uses the ____ function for numbers in the Values area and the _____ function for text and other nonnumeric values

To format the appraised value numbers in the pivot table:

The __________ report layout is the default layoiut for PivotTable reports. It places all fields from the row area in a single column and indents the items from each field below the outer fields.

In the _____ report layout, each field in the row area takes a column in the PivotTable. By default, the ____ form shows the subtotals for each group at the top of every group.

The ______ report layout displays one column for each field and leaves space for column headers. A total for each group appears at the bottom of each group.

Anything you do in the active sheet is automatically _____________, saving you time and ensuring consistency

When worksheets are grouped, the workedbook is in ________ mode and "[____]" appears in the title bar

The name of the active sheet in the worksheet group is ____

You can click any tab outside the worksheet group to exit __________ mode

A _________ ____ is a collection of two or more selected worksheets

A ________ _______ is a reference to the same cell or range in the multiple worksheets in the same workbook

When two or more worksheets have identical row and column layouts, you can enter formulas with ______ ________ to summarize those worksheets in another worksheet