If Jamie decides that she wants to work with nonnumeric data in her PivotTable,what function must she use to produce summaries?
A) SUM
B) AGGREGATE
C) TOTAL
D) COUNT

Question

Quizplus · Accepted Answer

If Jamie wants to work with nonnumeric data in her PivotTable, she should use the COUNT function to produce summaries. COUNT counts the number of non-blank cells in a range, which is useful for summarizing nonnumeric data such as text or dates. Since nonnumeric data cannot be summed, the SUM and TOTAL functions would not be appropriate choices. The AGGREGATE function is a more advanced function that allows for more complex summary calculations in PivotTables, but it is not necessary for counting nonnumeric data.

If Jamie Decides That She Wants to Work with Nonnumeric