BUS 311 Excel Chapter 5 2026| COMPLETE EXAM
SET (questions and verified answers)frequently
most tested questions | already passed!!
Save
Practice questions for this set
Learn 1 /7 Study with Learn
Sort by Department
Choose an answer
A worksheet of faculty members at your university contains these columns in this
1 sequence: Rank, Last Name, First Name, Department, and Salary. What is the first step
to subtotal departmental salaries?
2 A subtotal row must contain at least one _____________ function.
3 The _________ function is the default summary statistic for PivotTables.
, A(n)____________ is an interactive table which uses calculations to consolidate and
4
summarize information.
Don't know?
Terms in this set (85)
A subtotal row must contain at least Aggregate
one _____________ function.
What does a + button indicate to the You can expand the details of that category.
left of a row heading in an outline?
A worksheet of faculty members at Sort by Department
your university contains these
columns in this sequence: Rank, Last
Name, First Name, Department, and
Salary. What is the first step to
subtotal departmental salaries?
Which function is not a Subtotal AGGREGATE
function?
Grouping is __________________. joining rows or columns of related data into a
single entity for analysis
A(n)____________ is an interactive table PivotTable
which uses calculations to
consolidate and summarize
information.
SET (questions and verified answers)frequently
most tested questions | already passed!!
Save
Practice questions for this set
Learn 1 /7 Study with Learn
Sort by Department
Choose an answer
A worksheet of faculty members at your university contains these columns in this
1 sequence: Rank, Last Name, First Name, Department, and Salary. What is the first step
to subtotal departmental salaries?
2 A subtotal row must contain at least one _____________ function.
3 The _________ function is the default summary statistic for PivotTables.
, A(n)____________ is an interactive table which uses calculations to consolidate and
4
summarize information.
Don't know?
Terms in this set (85)
A subtotal row must contain at least Aggregate
one _____________ function.
What does a + button indicate to the You can expand the details of that category.
left of a row heading in an outline?
A worksheet of faculty members at Sort by Department
your university contains these
columns in this sequence: Rank, Last
Name, First Name, Department, and
Salary. What is the first step to
subtotal departmental salaries?
Which function is not a Subtotal AGGREGATE
function?
Grouping is __________________. joining rows or columns of related data into a
single entity for analysis
A(n)____________ is an interactive table PivotTable
which uses calculations to
consolidate and summarize
information.
