Java Games: Flashcards, matching, concentration, and word search.

ExcelAdv_Lesson 15_Introducing Pivot Tables_Activity

AB
Pivot Tablea dynamic summary report generated from a database.
DataContains a value or data to be summarized.
CategoryDescribes the data.
NormalizedA database table that is appropriate for a pivot table.
Column labelA field that has a column orientaiton in the pivot table.
Grand totalsA row or column that displays totals for all cells in a row or column in a pivot table.
GroupA collection of items treated as a single item.
ItemAn element in a field that appears as a row or column header in a pivot table.
RefreshRecalculates the pivot table after making changes to the source data.
Row labelsA field that has a row orientation in the pivot table.
Source dataThe data used to create a pivot table.
SubtotalsA row or column that displays subtotals for detail cells in a row or column in a pivot table.
Table FilterA field that has a page orientation in the pivot table.
Values areaThe cells in a pivot table that contain the summary data.


Instructor
triOS College
Kitchener, ON

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities