com s 113 study guide test 2

Data series

Related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend.

database

an organized collection of facts related to a specific topic

Fields button

A button on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart.

column chart

A chart in which the data is arranged in columns and that is useful for showing data changes over a period of time or for illustrating comparisons among items.

data marker

A column, bar, area, dot, pie slice, or other symbol in chart that represents a single data point; related data points form a data series

advanced filters

A filter that can specify three or more criteria for a particular column, apply complex criteria to two or more columns, or specify computed criteria.

custom filters

A filter with which you can apply complex criteria to a single column.

tredline

A graphic representation of trends in a data series, such as a line sloping upward to represent increased sales over a period of months.

PivotChart report

A graphical representation of the data in a PivotTable report.

PivotTables filters area

An area in the lower portion of the PivotTable Fields pane to position fields by which you want to filter the PivotTable report, enabling you to display s subset of data in the PivotTable report

PivotTables values area

An area to position fields that contain data that is summarized in a PivotTable report or PivotChart report. The data placed here is usually numeric or financial in nature and the data is summarize‐ summed. You can also perform other basic calculations such as finding the average, the minimum, or the maximum.

PivotTable rows area

An area to position fields that you want to display as rows in the PivotTable report. Field names placed here become row titles, and the data is grouped by these row titles.

PivotTable

An interactive Excel report that summarizes and analyzes large amounts of data.

criteria

Conditions that you specify in a logical function or filter.

navigate and manage large worksheet

Go to special command: to move cells that have special characteristics, ex- to cells that are blank or to cells that contain constants as opposed to formulas

comparison operators

Symbols that evaluate each value to determine if it is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria

compound criteria

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

sparklines

Tiny charts that fit within a cell and give a visual trend summary alongside data.

record

all the categories of data pertaining to one person, place, thing, event, or idea