DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
PivotChart
|
|
PivotTable
|
|
PivotDate
|
|
Rotate Table
|
Detailed explanation-1: -About PivotTables A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data. A PivotTable is especially designed for: Querying large amounts of data in many user-friendly ways.
Detailed explanation-2: -Pivot Table Slicers. Another way to filter a pivot table is with one or more Slicers. Pivot Table Slicers can apply filters to a single pivot table, or you can connect them to multiple pivot tables (from the same source data). Then, just click a button on a Slicer, to quickly filter all the connected pivot tables.
Detailed explanation-3: -Summarize Values By By default, PivotTable fields in the Values area will be displayed as a SUM.