Asked by Krista McGonigle on Jun 17, 2024
Verified
Which of the following is the default function Excel uses to summarize text data in a PivotTable?
A) SUM
B) COUNT
C) MIN
D) VAR
PivotTable
A feature in spreadsheet programs that allows users to dynamically reorganize and summarize large data sets into a concise report.
Text Data
Information represented in the form of words, sentences, or paragraphs, often utilized in data processing and textual analysis.
- Know the default functions Excel uses to summarize data in PivotTables and PivotCharts.
Verified Answer
LC
Lexxus CharlesJun 24, 2024
Final Answer :
B
Explanation :
The default function Excel uses to summarize text data in a PivotTable is COUNT. This function counts the number of instances of each text value in the selected field and displays the result in the PivotTable. The other options (SUM, MIN, and VAR) are used to summarize numerical data.
Learning Objectives
- Know the default functions Excel uses to summarize data in PivotTables and PivotCharts.