Excel tutorial 5 – Flashcards

Unlock all answers in this set

Unlock answers
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
Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New