KEY TERMS Calculated field A user-defined field that performs an arithmetic calculation based on other fields in a – PivotTable. Columns area The region in which to place a field that will display labels to organize data vertically in a – PivotTable. Data mining The process of analyzing large volumes of data to identify patterns and trends. – Filters area The region in which to place a field so that the user can then filter the data by that field in – a PivotTable or PivotChart. Grouping (1) The process of joining rows or columns of related data into a single entity so that groups – can be collapsed or expanded for data analysis. (2) The process of selecting worksheets to perform the same action at the same time. Outline A hierarchal structure of data organized so that groups can be expanded to show details or – collapsed to show high-level structure. PivotChart A graphical representation of data in a PivotTable. – PivotTable An interactive organization of data that consolidates and aggregates data by categories – that can be sorted, filtered, and calculated. PivotTable Fields task pane A window that enables a user to specify what fields are used from a – dataset and how to organize the data in columns, rows, values, and filters. PowerPivot A PivotTable functionality in which two or more related tables can be used to extract data – into a PivotTable. Relationship A connection between two or more tables using a common field, such as an ID field. – Rows area The region in which to place a field that will display labels to organize data horizontally in a – PivotTable. Slicer A window listing all items in a field so that the user can click a button to filter data by that – particular item or value. Slicer caption The text or field name that appears as a header or title at the top of a slicer to identify – the data in that field. Subtotal An aggregate calculation, such as SUM or AVERAGE, that applies to a subcategory of related – data within a larger dataset. SUBTOTAL function A math or trig function that calculates the total of values contained in two or – more cells.
KEY TERMS Calculated field – A user-defined field that performs an arithmetic calculation based on other fields in a PivotTable. Columns area – The region in which to place a field that will display labels to organize data vertically in a PivotTable. Data mining – The process of analyzing large volumes of data to identify patterns and trends. Filters area – The region in which to place a field so that the user can then filter the data by that field in a PivotTable or PivotChart. Grouping – (1) The process of joining rows or columns of related data into a single entity so that groups can be collapsed or expanded for data analysis. (2) The process of selecting worksheets to perform the same action at the same time. Outline – A hierarchal structure of data organized so that groups can be expanded to show details or collapsed to show high-level structure. PivotChart – A graphical representation of data in a PivotTable. PivotTable – An interactive organization of data that consolidates and aggregates data by categories that can be sorted, filtered, and calculated. PivotTable Fields task pane – A window that enables a user to specify what fields are used from a dataset and how to organize the data in columns, rows, values, and filters. PowerPivot – A PivotTable functionality in which two or more related tables can be used to extract data into a PivotTable. Relationship – A connection between two or more tables using a common field, such as an ID field. Rows area – The region in which to place a field that will display labels to organize data horizontally in a PivotTable. Slicer – A window listing all items in a field so that the user can click a button to filter data by that particular item or value. Slicer caption – The text or field name that appears as a header or title at the top of a slicer to identify the data in that field. Subtotal – An aggregate calculation, such as SUM or AVERAGE, that applies to a subcategory of related data within a larger dataset. SUBTOTAL function – A math or trig function that calculates the total of values contained in two or more cells.
e05_instructormanual.docx