USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
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: -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: -You can summarize a PivotTable by placing a field in ∑ VALUES area in the PivotTable Fields Task pane. By default, Excel takes the summarization as sum of the values of the field in ∑ VALUES area. However, you have other calculation types, such as, Count, Average, Max, Min, etc.
Detailed explanation-5: -You can base the defaults on that pivot table. Open the workbook that contains the pivot table. Select one cell in the pivot table. Go to File, Options, Advanced, Data, and click the button for Edit Default Layout.