question

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

answer

Table Name

question

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

answer

field

question

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.

answer

header row

question

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

answer

record

question

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

answer

rearrange or sort

question

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

answer

field name or column header

question

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

answer

sort icon

question

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

answer

filter arrow

question

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

answer

Excel table

question

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

answer

sort fields

question

To return to cell A1 you press

answer

CTRL HOME

question

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

answer

freezing

question

To delete a record

answer

In the cells group on the home tab, click the Delete button arrow, and then click delete table rows. the record for the trappers painting is deleted from the table.

question

To sort data

answer

click the data tab on the ribbon. The data options appear on the ribbon. Click Sort A to Z or Z to A in the Sort & Filter group.

question

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

answer

custom list

question

Excel provides ____ predefined custom sort lists

answer

4

question

_____ ___ to hide or display the total row

answer

check box

question

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

answer

total row

question

The _____ ___ indicates that the table is filtered

answer

status bar

question

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

answer

split bar; resize

question

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

answer

filter menu

question

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

answer

Filtering

question

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

answer

Pane

question

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

answer

AutoFilter

question

You can filter a column of data by its

answer

cell colors or font colors; by a specific text, number or date filter, although the choices depend on the type of data in the column; or by selecting the exact values by which you want to filter in the column.

question

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

answer

Clear Filter

question

row numbers of the _____ ______ are blue

answer

filtered records

question

___ ___ indicates the number of records displayed

answer

status bar

question

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

answer

Criteria

question

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

answer

the most commonly used functions

question

You can summarize data in a range by

answer

inserting subtotals

question

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

answer

counts, sums, averages, minimums, and maximums

question

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

answer

range; grand total row

question

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

answer

convert the excel table to a range

question

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

answer

PivotTable

question

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

answer

Value Fields

question

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

answer

PivotChart

question

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

answer

slicer

question

You create a PivotTable using the ______ ____.

answer

Field List

question

You click one or more slicer buttons ____ _____ the PivotTable

answer

to filter

question

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

answer

Category Fields

question

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

answer

row labels, column labels, and report filters

question

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.

answer

Report Filter

question

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.

answer

Row Labels

question

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.

answer

Column Labels

question

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

answer

Values

question

How do you get to the PivotTable button?

answer

Click insert tab on the Ribbon, and then, in the Tables group, click the PivotTable button.

question

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

answer

SUM; COUNT

question

To format the appraised value numbers in the pivot table:

answer

click any cell in the sum of appraised value column of the pivot table report, then click the PivotTable tools options tab on the Ribbon, then click the Field Settings button in the Active Field Group.

question

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.

answer

compact report layout

question

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.

answer

Outline; outline

question

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.

answer

Tabular

question

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

answer

done to all sheets in the worksheet group

question

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

answer

group-editing; Group

question

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

answer

bold

question

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

answer

group-editing

question

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

answer

worksheet group

question

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

answer

3-D reference

question

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

answer

3-d References

Excel tutorial 5 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards