Microsoft Excel 2019 basics

Absolute Cell Reference

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

Cell References

Address of a cell indicating its column and row location.

Comparison Operator

Symbol which indicates the relationship between two values.

Conditional Format

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

Data Series

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

Data Source

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

Date and Time Data

Recognized formats for date and time values.

DATE Function

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

Filtering Displays

Only shows data which meets certain criteria.

Footer Text

Printed on the bottom margin of each page.

Formula

Expression which returns a value.

Formula View

View of workbook contents which displays formulas instead of resulting values.

Function

Named operation which returns a value.

Manual Page Break

Allows a user to specify where a page break is located in a worksheet.

Mixed Cell Reference

Contains both relative and absolute references.

NOW Function

Displays the current date and time according to the formatting of the cell.

Sparkline

Tiny chart in the background of a cell.

Text Data

Combination of letters, numbers, and some symbols which form words and sentences.

TODAY Function

Places current date in a cell.

Workbook

File used to store worksheets.

Worksheets

Sheets containing formulas, functions, values, text, and graphics which make up a workbook.

Relative Cell References

address of a cell range based on the relative position of the cell