Excel Unit Definitions

Select all Box

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

Show Formulas

A command that displays the formula in each cell instead of the resulting value.

row

A horizontal group of cells in a worksheet.

Column

A vertical group of cells in a worksheet.

Average Function

An Excel function that adds a group of values, and then divides the result by the number of values in the group.

Formula

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

Auto Fill

An excel feature that generates and extended values into adjacent cells based on the values of selected cells.

X-axis

Another name for Horizontal axis.

spreadsheet

Another name for a worksheet.

Y-axis

Another name for the vertical axis.

Active cell

The cell surrounded by a black border, ready to receive data or be affected by the next excel command.

Chart

The graphic representation of data in a worksheet; data presented as a chart is usually easier to understand than a table of numbers.

Cell reference

The identification of a specific cell by its intersecting column letter and row number.

Cell

The intersection of a column and row.

Sheet Tabs

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

Freeze panes

To keep selected rows and/or columns of the worksheet visible on the screen as the rest of the worksheet scrolls

range

Two or more selected cells on a worksheet that are adjacent or nonadjacent because the range is treated as a single unit you can make the same changes or combination of changes to more than one cell at a time.

SUM Function

a predefined formula that adds all the numbers in a selected range of cells.

Min function

determines the lowest number in the range

Max function

displays the highest value in a range

Median function

identifies the midpoint value in a set of values

worksheet

the primary document that you use in excel to work with and store data and which is formatted as a pattern of uniformly spaced horizontal and vertical lines.

Legend

A chart element that identifies the patterns or colors that are assigned to the categories in the chart.

Filter

A device used to remove contamination from a fluid.

Workbook

A excel file containing one or many worksheets.

Function

A predefined formula a formula;a that excel has already built for you that preforms calculations by using specific values in a particular order.

Formula bar

An element in the Excel window that displays the value or formula contained in the active cell; here you can also enter or edit values or formulas.

name box

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

sort

Arrange the rows in a table or list of data in a new order according to the entries in one or more columns.

Fill Handle

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