Excel Chapter 1

Row

Horizontal group of cells in a worksheet.

Cell

Intersection of a column and row.

Sheet tabs

Labels along the lower border of the Excel window that identify each worksheet.

Select all box

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet..

Active cell

A cell surrounded by a black border and ready to receive data...

Range finder

A feature that outlines cells in color to indicate which cells are used in a formula.

Autofit

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column.

Formula bar

An element in the Excel window that displays the value or formula contained in the active cell...

Name box

An element of the Excel window that displays the name of the selected cell, table, chart, or object..

Formula

An equation that performs mathematical calculations on values in a worksheet.

Cell address

Another name for a cell reference.

Value

Another name for a constant value

Spreadsheet

Another name for a worksheet.

Cell content

Anything typed into a cell.

Category axis

Area along the bottom of a chart that identifies the categories of data

Number values

Constant values consisting of only numbers.

Underlying value

Data that displays in the formula bar is referred to as..

General format

Default format that Excel applies to numbers

Workbook

Excel file that contains one or more worksheets.

Chart

Graphic representation of data in a worksheet.

Constant value

Numbers, text, dates, or times of day that you type into a cell.

Workbook

On startup, Excel displays a new blank..

Fill handle

Small black square in the lower right corner of a selected cell.

Operators

Symbols with which you can specify the type of calculation you want to perform in an Excel formula

Data

Text or numbers in a cell.

Autofill

The Excel feature that generates and extends values into adjacent cells based on the values of selected cells

Absolute

The type of cell reference that refers to cells by their fixed position in a worksheet...

Sparklines

Tiny charts embedded in a cell that give a visual trend summary alongside your data

Column

Vertical group of cells in a worksheet.

Quick analysis tool

A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools like charts and color-coding