Search
Create
Log in
Sign up
Log in
Sign up
Intro to Excel Microsoft
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (8)
Cell Reference
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.
Range
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.
Formula
An equation that performs mathematical calculation on values in a worksheet.
Function
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.
Format
Changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read.
Worksheet
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.
;