BUS 1350 Exam II Questions with Correct Answers 100% Verified by Experts| 2025/2026
Latest Update
header row the first row of a data range, typically contains field names
data definition table 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 allows rows and/or columns labels or titles to remain stationary on the
screen while you scroll
splitting into panes Makes two panes that you can scroll through either
ascending order 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 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 ______. Sort A to Z and Sort Z to A
buttons
primary sort field to initially sort the data
secondary sort field for sorting data within the primary sort field
custom list 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 count, sum, average
, subtotals summary functions that are applied to a part of a data range
What is a field? cell in a table
What is a record? a group of related fields
What are the three freeze pane options? 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? no
Before you can add subtotals to a data range, what must you first do with the data? the data
must first be sorted by a field, such as the Office or Dept field
Find & Select 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, 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 filter the data
filtering data hides the rows whose values do not match the search criteria
criteria filters for more general criteria, expression involving dates and times, numeric
values, and text strings.
Latest Update
header row the first row of a data range, typically contains field names
data definition table 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 allows rows and/or columns labels or titles to remain stationary on the
screen while you scroll
splitting into panes Makes two panes that you can scroll through either
ascending order 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 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 ______. Sort A to Z and Sort Z to A
buttons
primary sort field to initially sort the data
secondary sort field for sorting data within the primary sort field
custom list 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 count, sum, average
, subtotals summary functions that are applied to a part of a data range
What is a field? cell in a table
What is a record? a group of related fields
What are the three freeze pane options? 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? no
Before you can add subtotals to a data range, what must you first do with the data? the data
must first be sorted by a field, such as the Office or Dept field
Find & Select 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, 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 filter the data
filtering data hides the rows whose values do not match the search criteria
criteria filters for more general criteria, expression involving dates and times, numeric
values, and text strings.
