BUS 1350 – Test 2, Risinger, 2026 – Study guide and practice material
When highlighting duplicate values with a conditional format, do the duplicate values have to
be adjacent to each other? - correct answer ✔✔ no
What is a field? What is a record? - correct answer ✔✔ field: a single characteristic of data that
appears in a table as a column
record: a collection of fields that appear as a row in a database or table
If you split the worksheet into panes at cell E3, how many panes are created? - correct answer
✔✔ four
What are the three freeze pane options? - correct answer ✔✔ freeze panes, freeze top row,
freeze first column
When an ascending sort order is used, how is a date-time field sorted? - correct answer ✔✔
Oldest to most recent
What is the difference between primary and secondary sort field? - correct answer ✔✔ Primary
initially sorts data, secondary sorts within the primary sort field
Before you can add subtotals to a data range, what must you first do with the data? - correct
answer ✔✔ Sort by field
What happens to worksheet rows that do not match the filter criteria? What happens to the
data they contain? - correct answer ✔✔ They are hidden
When multiple filter buttons are used with a data range, how are criteria in different fields
combined? - correct answer ✔✔ you can choose which values in that field to display
,Advanced filter - correct answer ✔✔ provide a way of writing more complicated filter criteria
that involve expression that combine fields using the AND and OR logical operators.
What happens to banded rows in an Excel table when you insert or delete a row? - correct
answer ✔✔ They automatically adjust
AVERAGE IF function - correct answer ✔✔ calculates the average of values for cells that match a
specified criteria
What is the structural reference to the table header row? - correct answer ✔✔ [#Headers]
What are two reasons for using slicers rather than filter buttons to filter data? - correct answer
✔✔ when data has a few distinct values that can be easily listed within the slicer, when you
want to perform data from a table on another worksheet.
What are two reasons for using filter buttons rather than slicers to filter data? - correct answer
✔✔ when you need to use criteria filters involving text, date, or numeric values
Can slicers be used with both data ranges and Excel tables? - correct answer ✔✔ yes
Can slicers be moved to any worksheet or external workbook? - correct answer ✔✔ yes
Pivot table - correct answer ✔✔ A PivotTable is an interactive table that groups and summarizes
data in a concise tabular format.
What are the four primary areas of a PivotTable? - correct answer ✔✔ Rows area, Columns
area, Values area, Filters area
, What default statistic is used for non-numeric data in the Values area of the PivotTable? -
correct answer ✔✔ Count
What default statistic is used for numeric data in the Values area of the PivotTable? - correct
answer ✔✔ Sum
By default, how does a PivotTable arrange the categories in a row or column? - correct answer
✔✔ Alphabetically for text fields; by date for date fields.
What happens when you place a date field in a row or column area? - correct answer ✔✔ Excel
automatically groups the dates, creating new fields for month, quarter, and year
What are two ways of filtering a PivotTable - correct answer ✔✔ By adding a field to the Filters
area of the table or by using the filter buttons for the fields in the row and column areas
What are the four areas of a PivotChart? - correct answer ✔✔ the Axis (Category area,the
Legend (Series) area,the Values area, andthe Filters area
Can you create a PivotChart without a PivotTable? - correct answer ✔✔ No, every PivotChart
must be based on a PivotTable somewhere within the workbook
Can any Excel chart type be turned into a PivotChart? - correct answer ✔✔ No, only the
following chart types can become PivotCharts: Column Line Pie Bar Area Surface Radar Combo
How do you apply the same slicer to multiple PivotTables? - correct answer ✔✔ Select the
slicer, click the Reports Connections button in Slicer group on the Slicer Tools Options tab, and
then select the PivotTables that the slicer is applied to
Can a timeline slicer be used with Excel tabs as well as PivotTables? - correct answer ✔✔ No,
they can be used only with PivotTables, they cannot be used with Excel tables
When highlighting duplicate values with a conditional format, do the duplicate values have to
be adjacent to each other? - correct answer ✔✔ no
What is a field? What is a record? - correct answer ✔✔ field: a single characteristic of data that
appears in a table as a column
record: a collection of fields that appear as a row in a database or table
If you split the worksheet into panes at cell E3, how many panes are created? - correct answer
✔✔ four
What are the three freeze pane options? - correct answer ✔✔ freeze panes, freeze top row,
freeze first column
When an ascending sort order is used, how is a date-time field sorted? - correct answer ✔✔
Oldest to most recent
What is the difference between primary and secondary sort field? - correct answer ✔✔ Primary
initially sorts data, secondary sorts within the primary sort field
Before you can add subtotals to a data range, what must you first do with the data? - correct
answer ✔✔ Sort by field
What happens to worksheet rows that do not match the filter criteria? What happens to the
data they contain? - correct answer ✔✔ They are hidden
When multiple filter buttons are used with a data range, how are criteria in different fields
combined? - correct answer ✔✔ you can choose which values in that field to display
,Advanced filter - correct answer ✔✔ provide a way of writing more complicated filter criteria
that involve expression that combine fields using the AND and OR logical operators.
What happens to banded rows in an Excel table when you insert or delete a row? - correct
answer ✔✔ They automatically adjust
AVERAGE IF function - correct answer ✔✔ calculates the average of values for cells that match a
specified criteria
What is the structural reference to the table header row? - correct answer ✔✔ [#Headers]
What are two reasons for using slicers rather than filter buttons to filter data? - correct answer
✔✔ when data has a few distinct values that can be easily listed within the slicer, when you
want to perform data from a table on another worksheet.
What are two reasons for using filter buttons rather than slicers to filter data? - correct answer
✔✔ when you need to use criteria filters involving text, date, or numeric values
Can slicers be used with both data ranges and Excel tables? - correct answer ✔✔ yes
Can slicers be moved to any worksheet or external workbook? - correct answer ✔✔ yes
Pivot table - correct answer ✔✔ A PivotTable is an interactive table that groups and summarizes
data in a concise tabular format.
What are the four primary areas of a PivotTable? - correct answer ✔✔ Rows area, Columns
area, Values area, Filters area
, What default statistic is used for non-numeric data in the Values area of the PivotTable? -
correct answer ✔✔ Count
What default statistic is used for numeric data in the Values area of the PivotTable? - correct
answer ✔✔ Sum
By default, how does a PivotTable arrange the categories in a row or column? - correct answer
✔✔ Alphabetically for text fields; by date for date fields.
What happens when you place a date field in a row or column area? - correct answer ✔✔ Excel
automatically groups the dates, creating new fields for month, quarter, and year
What are two ways of filtering a PivotTable - correct answer ✔✔ By adding a field to the Filters
area of the table or by using the filter buttons for the fields in the row and column areas
What are the four areas of a PivotChart? - correct answer ✔✔ the Axis (Category area,the
Legend (Series) area,the Values area, andthe Filters area
Can you create a PivotChart without a PivotTable? - correct answer ✔✔ No, every PivotChart
must be based on a PivotTable somewhere within the workbook
Can any Excel chart type be turned into a PivotChart? - correct answer ✔✔ No, only the
following chart types can become PivotCharts: Column Line Pie Bar Area Surface Radar Combo
How do you apply the same slicer to multiple PivotTables? - correct answer ✔✔ Select the
slicer, click the Reports Connections button in Slicer group on the Slicer Tools Options tab, and
then select the PivotTables that the slicer is applied to
Can a timeline slicer be used with Excel tabs as well as PivotTables? - correct answer ✔✔ No,
they can be used only with PivotTables, they cannot be used with Excel tables
