DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Count
|
|
|
Average
|
|
|
Max
|
|
|
Sum
|
Detailed explanation-1: -The Sum function is used by default for numeric value fields you place in your PivotTable, but here’s how to choose a different summary function: In the PivotTable, right-click the value field you want to change, and then click Summarize Values By. Click the summary function you want.
Detailed explanation-2: -Summarize Values By By default, PivotTable fields in the Values area will be displayed as a SUM. If Excel interprets your data as text, it will be displayed as a COUNT.
Detailed explanation-3: -Count Function. Count is the default summary function when fields with nonnumeric or blank cells are added to the Values area.
Detailed explanation-4: -If there are blank cells, or non-numeric data in the field, the Count function is used as a default. For fields that contain all numeric data, the Sum function is the default.