| A | B |
|---|
| Trendline | Visual way to describe the relationship of two variables in a table |
| Slicer | Easy filter data in a pivot table, pivot chart, or cube function |
| PivotTable | Interactive view of worksheet data that summarizes data by selecting catagories to group data; Allows PivotCharts to directly report data |
| Fields | Columns of data in a worksheet |
| Filtering | Viewing a subset that meets certain criterion only |
| Design | Ribbon visible when a PivotTable is selected, used to apply styles to the Pivot Table |
| Sum | Default method for summarizing data in a Pivot Table |
| Collapse/Expand | +/- Buttons that appear across the categories on a Pivot Table |
| Calculated Field | A field with values not entered as data, but determined by a computation involving data in other fields |
| Column | A chart that uses vertical rectangles to compare data |
| Line Chart | Shows trends (of data) over time |
| Chart Title | Element (usually) above the chart to make the data more meaningful |
| Legend | Element often to the right of the chart that identifies the color of each part of the chart |
| Gridlines | Chart element that helps improve readability of the chart |
| Plot Area | Main area of a graph--can select this to change the background color of the chart |
| Legend Fields | Display names of the series of data included on a chart |
| Values | To display a count of the data on a chart, drag the information to this location |
| Embedded Chart | Chart on the same worksheet as its data |
| Format | Used to add text effects to a Pivot Table |
| Data Labels | Use these to identify the exact value each data marker in a chart represents |
| Insert Ribbon | Ribbon that contains the commands to create charts in Excel |
| Numeric data and titles | Information typically included in the range of data used to create a chart |
| Exploded | Pie chart with offset pieces |
| Sparkline | Tiny chart that provides a visual representation of the data in a worksheet cell |
| Design Tab | Chart Tools Ribbon Tab used to select from a gallery of chart styles; PivotChart Tools Ribbon Tab used to apply a chart style to a PivotChart |
| Layout Tab | Chart Tools Ribbon Tab used to insert various labels on the chart; PivotChart Tools Ribbon Tab used to apply chart titles to the PivotChart |
| Trendline | Graphically represents trends in plotted data and predicts future values |
| Format Tab | Chart Tools Ribbon Tab used to apply a style to a chart |
| PivotChart | Interactive Graphical Representation of data that allows a user to change the groupings |
| WordArt | Creates decorative text in a worksheet |
| Screenshot | Command on the Insert Ribbon used to insert a picture of a program window into a worksheet |
| Screen Clipping | Command on the Insert Ribbon used to insert a picture of part of a screen into a worksheet |
| Clip Art | Command on the Insert Ribbon used to insert a graphic from the Microsoft Office Collection into a worksheet |
| Rotate | Command on the Page Layout Ribbon that flips objects in a worksheet |
