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 |