BUS 1350 TEST 2 RISINGER EXAM
QUESTIONS & ACTUAL CORRECT
ANSWERS ALL PASSED
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
QUESTIONS & ACTUAL CORRECT
ANSWERS ALL PASSED
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
