CIS111E Chapter 5 Subtotals PivotTables PivotCharts

Card Set Information

CIS111E Chapter 5 Subtotals PivotTables PivotCharts
2015-10-09 13:48:29

Chapter 5
Show Answers:

  1. Subtotal (p. 329)
    A row within the dataset containing at least one aggregated value when the category you specified in the At a change in option changes.
  2. Outline (p. 330)
    A hierarchical structure of data
  3. Grouping (p. 331)
    The process of joining rows or columns of related data together into a single entity.
  4. Data Mining (p. 336)
    The process of analyzing large volumes of data, using advanced statistical techniques, and identifying trends and patterns in the data.
  5. PivotTable (p. 336)
    Is a powerful, interactive data-mining feature that enables you to summarize and analyze data, especially helpful when working with large datasets.
  6. PivotTable Fields Task Pane (p. 339)
    A window that enables you to drag fields to particular areas to build and arrange data in a PivotTable.
  7. Slicer (p. 350)
    A window listing all items in a field and enabling efficient filtering.
  8. Slicer caption (p. 351)
    Is text that displays in the header at the top of the slicer window.
  9. Calculated Field (p. 352)
    A user-defined field that does not exist in the original dataset.  It derives its values based on performing calculations on other original dataset values.
  10. PowerPivot (p. 360)
    is a built-in add-in program in Excel 2013 that enables you to import millions of rows of data from multiple data sources, create a relationship between two or more related tables within one workbook (similar to creating relationships among tables in Access), and maintain connections.
  11. Relationship (p. 360)
    Is an association between two related tables where both tables contain a related field of data, such as IDs.
  12. PivotChart (p. 362)
    Is an interactive graphical representation of the data in a PivotTable. A PivotChart presents the consolidated data visually.