USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The Sum function is applied to values in a Pivot Table by default. How can I change this so that values are automatically counted and not summed?
|
|
Insert the COUNT formula (=Count()) into the PivotTable.
|
|
|
Change the format of the values in the Pivot Table to General Numbers.
|
|
|
In the Calculations group, change the Summarize Values By to Count.
|
|
|
All of the options listed above are correct.
|
Explanation:
There is 1 question to complete.