How can we help?

You can also find more resources in our Help Center.

31 terms

Excel

Excel terms to practice as you work through the Excel Unit.
STUDY
PLAY
Absolute cell reference
Does not change when copied or moved to a new cell
Argument
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
Cell
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
Chart
A graphical representation of data
Column
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
Fill
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
Formula
An equation that calculates a new value from values currently in a worksheet
Formula
The equation used to calculate values in a cell
Label
a text entry such as a heading used to identify a column of data.
Legend
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
Range
A group of selected cells
Relative cell reference
Adjusts to its new location when copied or moved
Row
Appears horizontally and is identified by numbers on the left side of the worksheet window
Spreadsheet
A grid of rows and columns in which you enter text, numbers, and the results of calculations
Value
Any input in a cell that can be used in mathematical equations (numbers and formulas)
Workbook
The file used to store worksheets
Worksheet range
A group of adjacent worksheets
Worksheet
A computerized spreadsheet
3-D Cell Reference
A reference to the same cell or range in multiple worksheets that you use in a formula