| A | B |
|---|
| validation | feature that ensures that data entered into a range of cells is within limits |
| link | data connection between workbooks that maintains control over critical data |
| styles | group that contains the command used for quickly converting selected cells to a table by choosing a table style |
| theme | set of formatting choices that includes a set of colors, fonts, and effects that you can aply to a worksheet to enhance its appearance |
| page layout | ribbon that contains the command to apply a theme to a worksheet |
| home | ribbon that includes the commands to apply a quick table style to a range of cells |
| autofilter | the technique that uses the table column heading arrows to narrow data in a table to show only specific items that meet criteria |
| trendline | visual way to show how two variables relate to each other in a table |
| PivotTable | an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories to group data |
| PivotChart | an interactive graphical representation of data that allows a user to change the groupings |
| slicers | graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts |
| fields | these are drawn in columns in the worksheet data when creating a PivotTable |
| design | the ribbon visible when a pivottable is selected, and allows a user to apply various styles |
| sum | default method for summarizing data in a pivottable |
| delimited file | file containing data fields separated by a special character such as a comma |
| query | a way to qualify data by specifying a matching condition or asking a question of the data |
| string | a single character, word, or phrase in a cell typically used in searches |
| rotate | command on the Page Layout ribbon that enables a user to flip objects on a worksheet |
| protect sheet | command that prevents unwanted changes to data in a worksheet by specifying exactly what information may be changed |
| protect workbook | command that limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook |
