Excel Vocab

Front

Contains commands for common tasks in Excel with multiple tabs and groups.

Back

Ribbon

Front

Displays location or name of selected cell: _____

Back

Name Box

Front

Fills cells with info from reference cell; green square on lower right of a cell.

Back

Fill Handle

Front

____ references remain constant regardless of where copied.

Back

ABSOLUTE REFERENCE ($)

Front

In the _____, you can enter or edit data, a formula, or a function that will appear in a specific cell.

Back

Formula Bar

Front

_____ references change when a formula is copied to another cell.

Back

Relative

Front

Reorganize data by sorting alphabetically, numerically, etc.

Back

Sort

Front

Narrow down data in a worksheet to view needed information:

Back

Filters

Front

The ____ allow scrolling up/down or side to side. Click and drag the vertical or horizontal scroll bar.

Back

Scroll Bars

Front

Intersection of a row and a column.

Back

Cell