Excel Module 1 Cengage Vocabulary

The cell in which you are currently working.

• Active cell

• Active reference

• Current cell

• Current reference

An icon that is displayed below and to the right of a range that lets you easily create charts and other elements.

• Quick Access Toolbar

• Quick Analysis Tool

• What-if-Analysis

• Flash Fill

A computer program used to perform calculations and analyze and present numerical data.

• Workbook

• Worksheet

• Electronic Spreadsheet

• Electronic Presentation

Numbers, formulas, and functions used in calculations.

• Functions

• Arguments

• Values

• Cell Reference

An Excel feature that automatically fills in column or row data based on calculations you enter.

• Templates

• Fill and crop

• Quick Anaylsis

• Flash Fill

Symbols in a formula that indicate what type of calculation to perform on the cells, ranges, or values.

• Math

• function

• formula prefix

• calculation operators

Box to the left of the formula bar that shows the cell reference or name of the active cell.

• Cell box

• Formula bar

• Cell Name

• Name box

A set of instructions used to perform one or more numeric calculations, such as adding, multiplying, or averaging, on values or cells.

• task bar

• formula bar

• formula

• range

Descriptive text or other information that identifies data in rows, columns, or charts, but is not included in calculations.

• Range

• Cell References

• Labels

• Values

The intersection of a column and row in a worksheet or table.

• address

• box

• cell

• window