Spreedsheets

Insert Function

A button loacted on the formula bar that allows quick access to the Insert Function dialog box.

Absolute Reference

A cell reference that does not adjust when the formula is pasted to a new location.

Range

A colon inserted between two cell references.

Auto Fill

A feature that enables you to fill in a series of numbers, dates, or other items automatically in a specified range.

Auto Sum

A feature that you can use to insert a formula that sums a range of cells automatically.

Data Series

A group of related data points plotted in a chart that originates from rows or columns on a single worksheet.

Sheet Tab:

A means to access the different sheets in a workbook, located at the bottom of the spreadsheet.

Function

A predefined function in Excel.

Formula

A sequence of values, cell references and operators used to produce a new value from existing cells.

Toolbars

A series of buttons and menus in an application, which allows the user to perform functions quickly using the mouse.

Chart Wizard

A series of dialog boxes that lets you create a chart and customize it as you create it.

Spreadsheet

A table of values arranged in rows and columns.

Worksheet

A work area comprised of rows and columns, also known as a spreadsheet.

Workbook

An Excel file that contains one or more worksheets.

Bar Chart

Compares individual items. Categories are organized vertically, values horizontally to place more emphasis on comparing values than on time.

Formula Bar

Displays the contents of the current or active cell, located above the worksheet column headings.

Chart

Graphic representation of worksheet data.

Cell Reference

Identifies a particular cell

Data Label

Identifies specific points or series.

Chart Title

Identifies the purpose of the chart.

Legend

Key to the data represented by a chart.

Operators

Operators: Addition (+), Subtraction (-), Multiplication (*), and Division (/), also the colon (:) that separates cells in a range.

Gridlines

Optional lines on a chart.

Task Pane

Provides a quick means to execute commands. Displays when you start Excel and and enables you to create new workbooks or open and existing one.

Column Chart

Shows changes in data over a period of time or illustrates comparisons among items.

Pie Chart

Shows the relationship of items that make up data series to the sum of the items.

Line Chart

Shows trends in data at equal intervals.

Cell

The intersection of a row and column.

Value

The number resulting from the execution of a formula.

Order of Precedence

The order in which excel processes operations in a formula with more than one operation.

Alignment

The placement of cell data in a cell.

Fill Handle

The small black square on the bottom right corner of a selected cell.

Active Cell

The worksheet cell with a dark border; text or numbers you type appear in this cell and in the formula bar.

Merge and Center

To combine adjacent, or contiguous, cells into one large cell and center the data.

Templates

ready-made pages format, complete with margins, fonts, headers and footers, numbering, logos or any other kind of formatting the designer wants to appear on each page.