31 terms


Excel terms to practice as you work through the Excel Unit.
Absolute cell reference
Does not change when copied or moved to a new cell
The value the function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand
Cell reference
Identifies the cell, and is formed by combining the cell's column letter and row number
The intersection of a row and a column
Chart area
The entire chart and all other chart elements
Chart sheet
A separate sheet in the workbook that stores a chart
A graphical representation of data
Appears vertically and is identified by letters at the top of the worksheet window
Data label
Text or numbers that provide additional information about a data marker
Data source
Chart data
Data table
A grid that displays the data plotted in the chart
Embedded chart
After you select a chart type and style, the chart is inserted as an embedded chart in the center of the worksheet
Fill handle
Appears in the lower-right corner of the active cell or range, and is used to fill cells
Copies a cells contents and/or formatting into an adjacent cell or range
Formula Bar
Appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value
An equation that calculates a new value from values currently in a worksheet
The equation used to calculate values in a cell
a text entry such as a heading used to identify a column of data.
A list that identifies patterns, symbols, or colors used in a chart
Mixed cell reference
Cell references that contain both relative and absolute references
Order of evaluation
The sequence used to calculate the value of a formula
Range reference
How the range is identified; made up of the cell in its upper-left corner and the cell in its lower-left corner, separated by a colon
A group of selected cells
Relative cell reference
Adjusts to its new location when copied or moved
Appears horizontally and is identified by numbers on the left side of the worksheet window
A grid of rows and columns in which you enter text, numbers, and the results of calculations
Any input in a cell that can be used in mathematical equations (numbers and formulas)
The file used to store worksheets
Worksheet range
A group of adjacent worksheets
A computerized spreadsheet
3-D Cell Reference
A reference to the same cell or range in multiple worksheets that you use in a formula