Excel ch 1

Select all box

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

Active cell

A cell surrounded by a black border and ready to receive data is the:

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 such as charts, color-coding, and formulas is called:

Range finder

A feature that outlines cells in color to indicate which cells are used in a formula is called:

Column

A vertical group of cells in a worksheet.

Formula

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

Autofit

An excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:

Workbook

An excel file that contains one or more worksheets.

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.

Number values

Constant values comsisting of only numbers.

Workbook

On startup, excel displays a new blank:

Data

Text or numbers in a cell.

Category axis

The area along the bottom of a chart that identifies the categories of data is the:

Underlying value

The data that displays in the formula bar is referred to as the:

General format

The default format that excel applies to numbers is the:

Autofill

The excel feature that generates andextends values into adjacent cells based on the values of the selected cells is:

Chart

The graphic representation of data in a worksheet.

Cell

The intersection of a column and a row.

Sheet tabs

The labels along the lower border of the excel window that identify each worksheet.

Fill handle

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

Operators

The symbols with which you can specify the type of calculation you want to perform in an excel formula are:

Absolute

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

Sparklines

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

Name box

An element of the excel window that displays the name of the selected cell, table, chart, or object is the:

Constant value

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

Row

A horizontal group of cells in a worksheet.

Formula bar

An element in the excel window that displays the value or formula contained in the active cell is the: