Which of the following is the default function Excel uses to summarize non-numeric data in a PivotTable?
A) SUM
B) COUNT
C) MIN
D) VAR

Question

Quizplus · Accepted Answer

The default function Excel uses to summarize non-numeric data in a PivotTable is COUNT. This function counts the number of occurrences of each unique item in the data set, making it the best choice for summarizing non-numeric data such as text or dates. SUM, MIN, and VAR are all functions designed for numeric data and would not be appropriate for summarizing non-numeric data.

Which of the Following Is the Default Function Excel Uses