click below
click below
Normal Size Small Size show me how
AR ADV SS UNIT 4
Arkansas Advanced Spreadsheets Unit 4- Tables, Pivot Tables & PivotCharts
| Question | Answer |
|---|---|
| Ascending order | Sorts text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest |
| Category field | A field used to group the values in a PivotTable |
| Clear | To remove |
| Column header | Field Name |
| Criteria filter | Conditions that you specify for a filter |
| Custom list | The sequence you specify to sort data |
| Data definition table | Documentation that lists the fields to be maintained for each record and description of the information each field will include |
| Descending order | Sorts text in reverse alphabetical order from Z to A, numbers from largest to smallest, and dates from newest to oldest |
| Field | An attribute or characteristic of a person, place, or thing (such as a last name, address, city, or state) |
| Field name | A unique label that describes the contents of the data in a column; also called a column header |
| Filter | The process of temporarily hiding records that do not meet the specified criteria |
| Header row | The row of field names |
| PivotChart | A graphical representation of the data in a PivotTable in which you can interactively add, remove, filter, and refresh data fields |
| PivotTable | An interactive table that enables you to group and summarize either a range of data or a table into a concise, tabular format for easier reporting and analysis |
| Primary sort field | The first sort field |
| Record | A collection of related fields that are grouped together, each row represents one |
| Refresh | To update |
| Report filter | Filters the PivotTable to display summarized data for one or more field items or all field items area |
| Secondary sort field | The second sort field |
| Sort field | A field you use to order data |
| Total row | A row at the end of a table that is used to calculate summary statistics for the columns in the table |
| Value field | In a PivotTable, a field that contains summary data |