BUS 1350 – Exam II, 2026 – Study guide and practice material
header row - correct answer ✔✔ the first row of a data range, typically contains field names
data definition table - correct answer ✔✔ lists the fields included with each record, the type of
data stored in each field (such as numbers, text, or dates), and a short description of each field
freezing panes - correct answer ✔✔ allows rows and/or columns labels or titles to remain
stationary on the screen while you scroll
splitting into panes - correct answer ✔✔ Makes two panes that you can scroll through either
ascending order - correct answer ✔✔ arranged alphabetically from A to Z, numeric values are
sorted from smallest to largest, and date and time values are sorted from oldest to most recent
descending order - correct answer ✔✔ sorted from Z to A, numeric values are sorted from
largest to smallest, and dates and times are sorted from most recent to oldest
To sort data in an Excel worksheet you can use the ______. - correct answer ✔✔ Sort A to Z and
Sort Z to A buttons
primary sort field - correct answer ✔✔ to initially sort the data
secondary sort field - correct answer ✔✔ for sorting data within the primary sort field
custom list - correct answer ✔✔ arranges the field values in the sort order you specify
,You can summarize the data by applying summary functions such as ___, ___, and ___ to the
entire data range - correct answer ✔✔ count, sum, average
subtotals - correct answer ✔✔ summary functions that are applied to a part of a data range
What is a field? - correct answer ✔✔ cell in a table
What is a record? - correct answer ✔✔ a group of related fields
What are the three freeze pane options? - correct answer ✔✔ freeze panes, freeze top row,
freeze first column
When highlighting duplicate values with a conditional format, do the duplicate values have to
be adjacent to each other? - correct answer ✔✔ no
Before you can add subtotals to a data range, what must you first do with the data? - correct
answer ✔✔ the data must first be sorted by a field, such as the Office or Dept field
Find & Select - correct answer ✔✔ can locate cells that match a specified criterion, can also list
multiple cells that satisfy the specified criterion
To locate cells of a specific type, - correct answer ✔✔ click the Find & Select button in the
Editing group on the Home tab and then click Go To Special.
To find records based on search criteria that involve multiple fields, you must - correct answer
✔✔ filter the data
filtering data - correct answer ✔✔ hides the rows whose values do not match the search criteria
, criteria filters - correct answer ✔✔ for more general criteria, expression involving dates and
times, numeric values, and text strings.
text filters - correct answer ✔✔ useful for locating records based on all or part of a specified
text string
For more advanced text filters, you can use - correct answer ✔✔ wildcard characters, which are
symbols that match a character pattern
If you want to clear only one filter out of multiple filters, - correct answer ✔✔ click the filter
button for that field and then click Clear Filter on the filter menu.
advanced filtering - correct answer ✔✔ provides a way of writing more complicated filter
criteria that involve expression that combine fields using the AND and OR logical operators
criteria range - correct answer ✔✔ necessary to write an advanced filter, lays out the
specifications of the filter
The main exception of excel tables is - correct answer ✔✔ that you cannot add subtotals to an
Excel table because the table structure of field and records must be preserved, which doesn't
allow for the insertion of subtotal rows
calculated field - correct answer ✔✔ a field that can contain a formula that references other
fields in the table, updates automatically as other field values in the table change
structural reference - correct answer ✔✔ References to fields and elements in an Excel table,
enclosed within brackets
header row - correct answer ✔✔ the first row of a data range, typically contains field names
data definition table - correct answer ✔✔ lists the fields included with each record, the type of
data stored in each field (such as numbers, text, or dates), and a short description of each field
freezing panes - correct answer ✔✔ allows rows and/or columns labels or titles to remain
stationary on the screen while you scroll
splitting into panes - correct answer ✔✔ Makes two panes that you can scroll through either
ascending order - correct answer ✔✔ arranged alphabetically from A to Z, numeric values are
sorted from smallest to largest, and date and time values are sorted from oldest to most recent
descending order - correct answer ✔✔ sorted from Z to A, numeric values are sorted from
largest to smallest, and dates and times are sorted from most recent to oldest
To sort data in an Excel worksheet you can use the ______. - correct answer ✔✔ Sort A to Z and
Sort Z to A buttons
primary sort field - correct answer ✔✔ to initially sort the data
secondary sort field - correct answer ✔✔ for sorting data within the primary sort field
custom list - correct answer ✔✔ arranges the field values in the sort order you specify
,You can summarize the data by applying summary functions such as ___, ___, and ___ to the
entire data range - correct answer ✔✔ count, sum, average
subtotals - correct answer ✔✔ summary functions that are applied to a part of a data range
What is a field? - correct answer ✔✔ cell in a table
What is a record? - correct answer ✔✔ a group of related fields
What are the three freeze pane options? - correct answer ✔✔ freeze panes, freeze top row,
freeze first column
When highlighting duplicate values with a conditional format, do the duplicate values have to
be adjacent to each other? - correct answer ✔✔ no
Before you can add subtotals to a data range, what must you first do with the data? - correct
answer ✔✔ the data must first be sorted by a field, such as the Office or Dept field
Find & Select - correct answer ✔✔ can locate cells that match a specified criterion, can also list
multiple cells that satisfy the specified criterion
To locate cells of a specific type, - correct answer ✔✔ click the Find & Select button in the
Editing group on the Home tab and then click Go To Special.
To find records based on search criteria that involve multiple fields, you must - correct answer
✔✔ filter the data
filtering data - correct answer ✔✔ hides the rows whose values do not match the search criteria
, criteria filters - correct answer ✔✔ for more general criteria, expression involving dates and
times, numeric values, and text strings.
text filters - correct answer ✔✔ useful for locating records based on all or part of a specified
text string
For more advanced text filters, you can use - correct answer ✔✔ wildcard characters, which are
symbols that match a character pattern
If you want to clear only one filter out of multiple filters, - correct answer ✔✔ click the filter
button for that field and then click Clear Filter on the filter menu.
advanced filtering - correct answer ✔✔ provides a way of writing more complicated filter
criteria that involve expression that combine fields using the AND and OR logical operators
criteria range - correct answer ✔✔ necessary to write an advanced filter, lays out the
specifications of the filter
The main exception of excel tables is - correct answer ✔✔ that you cannot add subtotals to an
Excel table because the table structure of field and records must be preserved, which doesn't
allow for the insertion of subtotal rows
calculated field - correct answer ✔✔ a field that can contain a formula that references other
fields in the table, updates automatically as other field values in the table change
structural reference - correct answer ✔✔ References to fields and elements in an Excel table,
enclosed within brackets
