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
Identifies the cell, and is formed by combining the cell's column letter and row number
The intersection of a row and a column
The entire chart and all other chart elements
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
Text or numbers that provide additional information about a data marker
A grid that displays the data plotted in the chart
After you select a chart type and style, the chart is inserted as an embedded chart in the center of the worksheet
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
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
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
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
Please allow access to your computer’s microphone to use Voice Recording.
We can’t access your microphone!
Click the icon above to update your browser permissions above and try again
Reload the page to try again!
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Your microphone is muted
For help fixing this issue, see this FAQ.