BUS 311 EXCEL CHAPTER 5 2025| COMPLETE EXAM SET
(QUESTIONS AND VERIFIED ANSWERS)FREQUENTLY MOST
TESTED QUESTIONS | ALREADY PASSED!!
Question 1
A subtotal row in Excel must contain at least one of which type of function?
A) SUMIF
B) COUNTIF
C) AVERAGEIF
D) Aggregate
E) MAXIF
Correct Answer: D) Aggregate
Rationale: The text states, "A subtotal row must contain at least one
Aggregate function."
Question 2
In an Excel outline, what does a "+" button indicate to the left of a row
heading?
A) The row contains an error.
B) The row is locked and cannot be edited.
C) You need to manually refresh the data.
D) The row is part of a hidden filter.
E) You can expand the details of that category.
Correct Answer: E) You can expand the details of that category.
Rationale: A "+" button indicates that you can expand the details of
that category.
,Question 3
You have a worksheet of university faculty members with columns: Rank,
Last Name, First Name, Department, and Salary. What is the essential first
step to accurately subtotal departmental salaries?
A) Create a PivotTable.
B) Use the AGGREGATE function.
C) Filter by Salary.
D) Sort by Department.
E) Group rows manually.
Correct Answer: D) Sort by Department.
Rationale: The first step to subtotal departmental salaries is to "Sort
by Department."
Question 4
Which of the following functions is explicitly stated as not being a Subtotal
function in the provided context?
A) SUM
B) AVERAGE
C) COUNT
D) MAX
E) AGGREGATE
Correct Answer: E) AGGREGATE
Rationale: The input explicitly states, "Which function is not a
Subtotal function? AGGREGATE." (Note: In standard Excel,
, AGGREGATE can perform subtotal-like calculations, but this question
refers to a specific interpretation from the provided study set where
it's listed as NOT a Subtotal function itself.)
Question 5
What is the process of joining rows or columns of related data into a single
entity for analysis?
A) Filtering
B) Sorting
C) Calculating
D) Summarizing
E) Grouping
Correct Answer: E) Grouping
Rationale: Grouping is defined as "joining rows or columns of related
data into a single entity for analysis."
Question 6
What is an interactive table which uses calculations to consolidate and
summarize information?
A) Data Table
B) Chart
C) Worksheet
D) Database
E) PivotTable
Correct Answer: E) PivotTable
(QUESTIONS AND VERIFIED ANSWERS)FREQUENTLY MOST
TESTED QUESTIONS | ALREADY PASSED!!
Question 1
A subtotal row in Excel must contain at least one of which type of function?
A) SUMIF
B) COUNTIF
C) AVERAGEIF
D) Aggregate
E) MAXIF
Correct Answer: D) Aggregate
Rationale: The text states, "A subtotal row must contain at least one
Aggregate function."
Question 2
In an Excel outline, what does a "+" button indicate to the left of a row
heading?
A) The row contains an error.
B) The row is locked and cannot be edited.
C) You need to manually refresh the data.
D) The row is part of a hidden filter.
E) You can expand the details of that category.
Correct Answer: E) You can expand the details of that category.
Rationale: A "+" button indicates that you can expand the details of
that category.
,Question 3
You have a worksheet of university faculty members with columns: Rank,
Last Name, First Name, Department, and Salary. What is the essential first
step to accurately subtotal departmental salaries?
A) Create a PivotTable.
B) Use the AGGREGATE function.
C) Filter by Salary.
D) Sort by Department.
E) Group rows manually.
Correct Answer: D) Sort by Department.
Rationale: The first step to subtotal departmental salaries is to "Sort
by Department."
Question 4
Which of the following functions is explicitly stated as not being a Subtotal
function in the provided context?
A) SUM
B) AVERAGE
C) COUNT
D) MAX
E) AGGREGATE
Correct Answer: E) AGGREGATE
Rationale: The input explicitly states, "Which function is not a
Subtotal function? AGGREGATE." (Note: In standard Excel,
, AGGREGATE can perform subtotal-like calculations, but this question
refers to a specific interpretation from the provided study set where
it's listed as NOT a Subtotal function itself.)
Question 5
What is the process of joining rows or columns of related data into a single
entity for analysis?
A) Filtering
B) Sorting
C) Calculating
D) Summarizing
E) Grouping
Correct Answer: E) Grouping
Rationale: Grouping is defined as "joining rows or columns of related
data into a single entity for analysis."
Question 6
What is an interactive table which uses calculations to consolidate and
summarize information?
A) Data Table
B) Chart
C) Worksheet
D) Database
E) PivotTable
Correct Answer: E) PivotTable
