| A | B |
|---|
| The first row of a table that contains the column headings is called the field names row or this row. | Header |
| Typing a formula in the first row of a column in a table causes Excel to define the field as this type of column. | Calculated Column |
| This is the term that describes the formatting feature in a table in which even rows are formatted differently than odd rows. | Banded Rows |
| Change the visual appearance of a table using this gallery in the Table Tools Design tab. | Table Styles |
| Clicking this button causes the Convert Text to Columns wizard to appear. | Text to Columns |
| Open this dialog box to instruct Excel to compare the entries in the columns you specify and automatically delete rows that contain repeated data. | Remove Duplicates |
| Open this dialog box to restrict entries in a cell to those that you set up in a drop-down list. | Data Validation |
| This option in the Allow list box is used to force data entered into a cell to be a specific number of characters. | Text Length |
| This is the default error alert style which prevents invalid data from being entered into a cell. | Stop |
| The Convert to Range button is found in this tab. | Table Tools Design |
| Prior to creating subtotals using the Subtotal button in the Outline group of the Data tab, arrange the data in this order. | Sort by the field to group records for subtotals |
| In a worksheet with subtotal rows only displayed, click this button next to a subtotal row in order to view the grouped rows. | Show Detail |
| Click this button in an outlined worksheet to collapse the rows for a group. | Hide Detail |
| In a DSUM function, the argument database refers to this range. | Range containing the data to be analyzed |
| In a DSUM function, the argument field refers to this cell. | The column heading for the column to sum |
| In a DSUM function, the argument criteria refers to this range. | The cells containing the field name and criteria used to select records to add |
| The SUBTOTAL function formula is located in this function category. | Math & Trig |
