BUS 1350 – Exam 2, 2026 – Study guide and practice material
Header Row - correct answer ✔✔ the first row of a data range, typically contains the field
names
Data Definition Table - correct answer ✔✔ Documentation that lists the fields to be maintained
for each record, a description of the information each field will include, and the type of data
stored in each field.
Before entering data, you should plan how that data should be structured to best achieve your
goals - correct answer ✔✔ True
How to split a workbook into 4 panes - correct answer ✔✔ To split the workbook window into
four panes, click any cell or range, and then click the Split button in the Window group on the
View tab.
How to split the window into two vertical panes - correct answer ✔✔ To split the window into
two vertical panes, select a cell in the first row, and then click the Split button.
How to split the window into two horizontal panes - correct answer ✔✔ To split the window
into two horizontal panes, select a cell in the first column, and then click the Split button
each______stores information known as a field - correct answer ✔✔ column
each______stores a record containing a group of related field values - correct answer ✔✔ row
a data sheet should be separated from other worksheet content by at least _______ blank row -
correct answer ✔✔ one
, excel can split a worksheet up into_____sections called panes - correct answer ✔✔ four
another way of viewing worksheets is by ________the split panes - correct answer ✔✔ freezing
you can use________to locate a duplicate record by highlighting duplicate values with a
selected range - correct answer ✔✔ conditional formatting
One Limit of using conditional formatting to locate duplicate records is that the process finds
duplicate values only in a ______ field. - correct answer ✔✔ single
you can use the _________ tool to delete records that are duplicated across multiple feilds. -
correct answer ✔✔ remove duplicates
You are NOT prompted to confirm the deletion of duplicate records. Instead, Excel keeps the
_____instance of any duplicates it finds and delete subsequent records. - correct answer ✔✔
first
you can sort fields in _______ order so that the text entries are arranged alphabetically from A-
Z, and numeric values are ordered smallest to largest - correct answer ✔✔ ascending
______ order puts text entries from Z-A and numeric values are sorted largest to smallest -
correct answer ✔✔ descending
Analyzing a large data range usually includes making calculations on the data. You can
summarize the data by applying the _____ functions such as COUNT AVERAGE and SUM -
correct answer ✔✔ summary
Some analysis requires calculations on sections of a data range. To do this you can add _______
which are summary functions that are applied to part of a data range. - correct answer ✔✔
subtotals
Header Row - correct answer ✔✔ the first row of a data range, typically contains the field
names
Data Definition Table - correct answer ✔✔ Documentation that lists the fields to be maintained
for each record, a description of the information each field will include, and the type of data
stored in each field.
Before entering data, you should plan how that data should be structured to best achieve your
goals - correct answer ✔✔ True
How to split a workbook into 4 panes - correct answer ✔✔ To split the workbook window into
four panes, click any cell or range, and then click the Split button in the Window group on the
View tab.
How to split the window into two vertical panes - correct answer ✔✔ To split the window into
two vertical panes, select a cell in the first row, and then click the Split button.
How to split the window into two horizontal panes - correct answer ✔✔ To split the window
into two horizontal panes, select a cell in the first column, and then click the Split button
each______stores information known as a field - correct answer ✔✔ column
each______stores a record containing a group of related field values - correct answer ✔✔ row
a data sheet should be separated from other worksheet content by at least _______ blank row -
correct answer ✔✔ one
, excel can split a worksheet up into_____sections called panes - correct answer ✔✔ four
another way of viewing worksheets is by ________the split panes - correct answer ✔✔ freezing
you can use________to locate a duplicate record by highlighting duplicate values with a
selected range - correct answer ✔✔ conditional formatting
One Limit of using conditional formatting to locate duplicate records is that the process finds
duplicate values only in a ______ field. - correct answer ✔✔ single
you can use the _________ tool to delete records that are duplicated across multiple feilds. -
correct answer ✔✔ remove duplicates
You are NOT prompted to confirm the deletion of duplicate records. Instead, Excel keeps the
_____instance of any duplicates it finds and delete subsequent records. - correct answer ✔✔
first
you can sort fields in _______ order so that the text entries are arranged alphabetically from A-
Z, and numeric values are ordered smallest to largest - correct answer ✔✔ ascending
______ order puts text entries from Z-A and numeric values are sorted largest to smallest -
correct answer ✔✔ descending
Analyzing a large data range usually includes making calculations on the data. You can
summarize the data by applying the _____ functions such as COUNT AVERAGE and SUM -
correct answer ✔✔ summary
Some analysis requires calculations on sections of a data range. To do this you can add _______
which are summary functions that are applied to part of a data range. - correct answer ✔✔
subtotals
