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
Q25: When you want to see all the
Q43: By default the PivotTable report uses the
Q59: You can calculate <span class="ql-formula"
Q69: Custom filters enable you to specify various
Q77: Table names cannot include underscores .
Q79: You can create at most one Excel
Q89: _ order arranges labels in reverse alphabetical
Q97: The entry 20000 is the _ for
Q99: You can display or hide filter arrows
Q123: When related fields are grouped together in