USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Pivot Table
|
|
|
IF Function
|
|
|
Columns
|
|
|
Cell Reference
|
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: -The beauty of pivot tables in excel is they allow you to interactively explore your data in different ways. Therefore, it helps to make data analysis easier and more effective.
Detailed explanation-3: -A Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them.