ITE 140 Exam 2

¡Supera tus tareas y exámenes ahora con Quizwiz!

Field names

Column titles from source data forming categories of data for PivotTable

CSV file

Comma-separated values file

Arrange All

Command to tile open Excel windows

Criteria

Conditions in logical function or filter

Criteria range

Defines filter criteria

Database

Organized collection of related facts

What is the command to update a PivotTable?

Refresh.

List

Series of rows containing related data with columns

Field

Single piece of information for every record

Descending

Sorted from Z to A, highest to lowest, or latest to earliest

Compound filter

A filter that uses more than one condition—and one that uses comparison operators.

Custom filter

Applies complex criteria to a column

Values area

Area for numeric/financial data in PivotTable

Filters area

Area in lower portion of PivotTable Fields pane to position fields for filtering PivotTable report

Columns area

Area to position fields displayed as columns in PivotTable report

What is the Rows area in a PivotTable?

Area to position fields displayed as rows.

What is a relationship in Excel?

Association between tables sharing a common field.

Field button

Button on PivotChart to choose a filter and change displayed data

Filtering button

Button on slicer to select item for filtering

Clear Filter

Button to remove a filter

What is meant by 'Record All'?

Categories of data for a person, place, event, thing, or idea.

What is meant by 'Source data'?

Data for a PivotTable formatted in columns and rows.

Cell style

Defined set of formatting characteristics

What is a Slicer in Excel?

Easy-to-use filtering control with buttons.

Primary key

Field used to uniquely identify a record in an Access table

Comma delimited file

File type with commas between cell contents

Advanced filter

Filter with 3+ criteria or computed criteria

PivotChart

Graphical representation of data in PivotTable report

End-of-paragraph mark

Indicates end of row in CSV file

PivotTable

Interactive Excel report summarizing and analyzing large amounts of data

Filter

Limit display of data to specific information

Area section

Lower portion of PivotTable Fields pane

AutoFilter menu

Menu to filter by values, format, or criteria

Data model

Method of incorporating data from multiple tables into Excel worksheet

And comparison operator

Operator requiring all criteria to be true

Associated PivotTable report

PivotTable report in a workbook represented in a PivotChart

Detail data

Subtotaled and summarized rows

Comparison operators

Symbols to evaluate values for criteria

Ascending

Text sorted A to Z, numbers lowest to highest

Compound criteria

The use of two or more criteria on the same row—all conditions must be met for the records to be included in the results.

What is a Slicer header?

Top of a slicer indicating the category of slicer items.

Field section

Upper portion of PivotTable Fields pane containing fields from source data

Custom list

User-defined sort order

PivotTable Fields pane

Window listing fields from source data for use in PivotTable and area to arrange fields

Active area

Worksheet area with data


Conjuntos de estudio relacionados

Chapter 4 "Wildland Fire Behavior"

View Set

NCLEX book CHAPTER 63- Neurological Medications

View Set

CSI 4321: TCP/IP Notes Chapter 5

View Set

Database Normalization & Implementation

View Set

Taylor ch 7 PrepU - Legal Dimensions

View Set

Resistance Training Equipment & Safety & Types of Exercises

View Set

Econ connect quiz questions -->April 6, 2018

View Set