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
