Excel 1 & 2
A cell reference that refers to a cell by its fixed position in a worksheet and does not change when the formula is copied
Absolute cell reference
The cell, surrounded by a green border, ready to receive data or be affected by the next excel command
Active cell
A chart line that contains words as labels
Argument
Symbols that specify mathematical operations such as addition or subtraction
Arithmetic operations
Automatically changing the column width to accomodate the longest column entry
Autofit
The function that adds a group of values and the divides the result by the number of values in the group
Average
The values that determine how a function should be used
Category axis
The column letter and row number that identify a cell
Cell address
The identification of a specific cell by its intersecting column letter and row number
Cell reference
A predesigned combination of chart elements.
Chart layout
A worksheet that contains only a chart
Chart sheet
A prebuilt chart format that applies an overall visual look to a chart
Chart style
A chart type useful for illustarting comparisons among related numbers
Column chart
The related data points in a chart
Data series
The data displayed in a cell
Displayed value
A green triangle that indicates a possible error in a formula
Error Indicator
The small green square in the lower right corner of the active cell
Fill handle
An equation that performs mathematical calculations on number values
Formula
An excel feature that suggest values as you type a function.
Formula autocomplete
An excel window area that displays the value contained in the active cell
Formula bar
A prewritten Excel Formula
Function
The box that identifies the patterns or colors assigned to the data series
Legend
The excel window area that displays the address of a selected cell
Name box
A view that maximizes the number of cells visible on the screen.
Normal view
Rules that specify the way numbers should display
Number format
Page headers and footers can be changed in this view
Page layout view
The chart type that best displays the relationship of parts to a whole
Pie chart
Tow or more cells on a worksheet
Range
The excel feature that outlines all of the cells referenced in a formula.
Range Finder
The number that displays at left of a row
Row heading
A command with which you can display text on multiple lines within a cell
Text wrap
data in a cell - text or numbers
Value
A chart line that contains numeric data
Value axis
An excel file that contains one or more worksheets
Workbook
The primary document that you use in Excel to store and work with data
Worksheet
A graphical representation of data in a worksheet that shows comparisons, patterns, and trends
chart
A chart placed on a worksheet with the source data
embedded chart
The default format applied to numbers
general format
Data in a cell made up of numbers only
number value
Data in a cell made up of text only
text value