Multiple Choice
Critical Thinking Case-Based Questions
Case 5-3
As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job.
If Ted decides that he wants to work with nonnumeric data in his PivotTable, what function must he use to produce summaries?
A) SUM
B) AGGREGATE
C) TOTAL
D) COUNT
Correct Answer:

Verified
Correct Answer:
Verified
Q35: Which of the following is a valid
Q35: The _ condition requires that all of
Q42: In Excel a collection of similar data
Q79: When you click in each cell in
Q88: Identify the letter of the choice that
Q89: When you designate a range as a(n)_
Q93: Identify the letter of the choice that
Q112: In Excel a table is a range
Q116: The _ criteria filter requires the records
Q123: When related fields are grouped together in