Excel Concepts Flashcards

Front

Absolute Cell Reference

Back

Points to a specific cell and does not change when copied; includes dollar signs in the reference name.

Front

Cell References

Back

Address of a cell indicating its column and row location.

Front

Comparison Operator

Back

Symbol which indicates the relationship between two values.

Front

Conditional Format

Back

Applies formatting only when a cell’s value meets a specified criterion.

Front

Data Series

Back

Range of values which is plotted as a single unit on the chart.

Front

Data Source

Back

Range which contains the data selected to display in the chart.

Front

DATE Function

Back

Creates a date value for the date represented by the year, month, and day arguments.

Front

Filtering

Back

Displays only data which meets certain criteria.

Front

Footer

Back

Text printed on the bottom margin of each page.

Front

Formula

Back

Expression which returns a value.