Intro to Excel Microsoft
Terms in this set (8)
The identification of a specific cell by its intersecting column letter and row number.
Absolute Cell Reference
A cell reference that refers to cells by their fixed position in a worksheet; an absolute cell reference remains the same when the formula is copied.
Relative Cell Reference
In a formula, the address of a cell based on the relative positions of the cell that contains the formula and the cell referred to in the formula.
Two or more selected cells on a worksheet that are adjacent or nonadjacent; because the range is treated as a single unit, you can make the same changes or combination of changes to more than one cell at a time.
An equation that performs mathematical calculation on values in a worksheet.
A predefined formula-a formula that Excel has already built for you-that performs calculations by using specific values in a particular order or structure.
Changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read.
The primary document that you use in Excel to work with and store data, and which is formatted as a pattern of uniformly spaced horizontal and vertical lines.