Term
|
Definition
| provide a way to quickly format an entire table using a present style definition |
|
|
Term
| A field name or column header |
|
Definition
| is a unique label that describes the contents of the data in a column |
|
|
Term
|
Definition
| is a range of related data that is managed independently from other data in the worksheet |
|
|
Term
| Each column represents a ____, which is a single piece of data |
|
Definition
|
|
Term
| A ____ describes a characteristic of a person, place, or thing, such as last name, a city, or product |
|
Definition
|
|
Term
| A structured range of data has |
|
Definition
| related records and fields organized in rows and columns |
|
|
Term
|
Definition
|
|
Term
|
Definition
| lists the fields to be maintained for each record, a description of the info. each field will include, and the type of data (such as numbers, texts, or dates) stored in each field |
|
|
Term
| Freezing a row or column lets you keep the |
|
Definition
| header visible as you work with the data in a large worksheet |
|
|
Term
|
Definition
|
|
Term
|
Definition
| The first row of the table that includes the field names |
|
|
Term
|
Definition
| A row at the bottom of the table that applies a function to the column values |
|
|
Term
|
Definition
| formatting added to the leftmost column of the table |
|
|
Term
|
Definition
| Formatting added to the rightmost column of the table |
|
|
Term
|
Definition
| formatting added to alternating rows so that even and odd rows are different colors making it simpler to distinguish records |
|
|
Term
|
Definition
| formatting added to alternating columns so they are different colors |
|
|
Term
|
Definition
| buttons that appear in each column of the header row and open a menu with options for sorting and filtering the table data |
|
|
Term
| To display or hide alternating columns colors |
|
Definition
| click the Banded Columns check box in the Table Style Options group |
|
|
Term
| You can drag the ______ to add columns or rows to the Excel Table or delete them from it |
|
Definition
|
|
Term
|
Definition
| is a quicker way to find a record and edit it |
|
|
Term
|
Definition
| arranges text alphabetically, numbers from smallest to largest, and dates from oldest to newest |
|
|
Term
|
Definition
| arranges text in reverse alphabetical order from Z to A, numbers from largest to smallest, and dates from newest to oldest |
|
|
Term
| In both ascending and descending order, |
|
Definition
| Blank Cells are placed at the end of the table |
|
|
Term
| First sort field is the ______, the second sort field is the ______, and so forth |
|
Definition
| primary sort field, secondary sort field |
|
|
Term
| You can include up to ___ sort fields in a single sort, typically one to three sort fields will be used |
|
Definition
|
|
Term
| when you have more than one sort field, you should use the _______ to specify the sort criteria |
|
Definition
|
|
Term
| A ______ indicates the sequence in which you want data ordered |
|
Definition
custom list
(sorting using a custom list) |
|
|
Term
| Excel has two predefined custom lists which are |
|
Definition
| day-of-the-week and month-of-the-year |
|
|
Term
Section 5.2
Flitering is the process of |
|
Definition
| displaying a subset of rows in an Excel Table or a structured range of data that meets the criteria you specify |
|
|
Term
|
Definition
| is an object used to filter data in an Excel table. It includes a button for each unique value in the field |
|
|
Term
|
Definition
| indicates the division between the panes. you can drag the split bar to resize the panes |
|
|
Term
| to view different areas or ____ of a large worksheet you can split the window into two or four resizable areas |
|
Definition
|
|
Term
|
Definition
| is used to calculate summary statistics (including sum, average, count, MAX and MIN) for any column in an Excel table |
|
|
Term
| If you want to change an Excel table back to a structured range of data, you click the _____ |
|
Definition
|
|
Term
| To show or hide filter buttons for an Excel Table, or a structured range of data |
|
Definition
| click the Filter button in the Sort & Filter group of the DATA tab |
|
|
Term
| When you want to redisplay all of the data in a filtered table, you need to ____ the filters. |
|
Definition
|
|
Term
| Another way to filter an Excel table is with ______ |
|
Definition
|
|
Term
| Every ___ consists of an object that contains a button for each unique value in that field |
|
Definition
|
|
Term
| To remove a slicer from the worksheet |
|
Definition
| select it and then press the Delete key |
|
|
Term
|
Definition
|
|
Term
| When you select Sum, Count, or Average, Excel uses |
|
Definition
| the SUBTOTAL function to calculate the summary statistic in the Total row |
|
|
Term
| _____ appears immediately below the split bar |
|
Definition
|
|
Term
|
Definition
| inserts a subtotal row into the range for each group of data and adds a grand total row below the last row of data |
|
|
Term
| The ______ feature "outlines" the worksheet so you can control the level of detail that is displayed |
|
Definition
|
|
Term
| To collpase the outline and hide the rows with details, click the |
|
Definition
|
|
Term
| A _____ is an interactive table used to group and summarize either a range of data or an Excel table into a concise, tabular format for reporting and analysis |
|
Definition
|
|
Term
| _______ are the fields that contain summary data in a PivotTable |
|
Definition
|
|
Term
| A ______ is a graphical representation of the data in a PivtoTable |
|
Definition
|
|
Term
| __________ are the fields that group the values in a PivotTable. |
|
Definition
|
|
Term
| _________ appear in PivotTables as row labels, column labels, and report filters |
|
Definition
|
|
Term
| Fields in the ____ area are displayed as rows in the PivotTable |
|
Definition
|
|
