Java Games: Flashcards, matching, concentration, and word search.

Creating Worksheet Formulas--Lesson 3

Creating Worksheet Formulas

AB
Absolute cell referenceA cell reference that does not change when the formula is copied or moved to a new location.
ArgumentA value, cell reference or address, range, or text that acts as an operand in a function formula.
Dependent cellsWorksheet formulas that reference a particular cell.
FormulaEquation used to calculate values in a spreadsheet cell.
Function formulaA special formula that names a function instead of using operators to calculate a result.
OperandNumber or cell reference, such as B5 or 6.
OperatorA symbol that tells Excel what mathematical operation to perform in a worksheet formula, such as a plus sign or multiplication sign.
Order of evaluationThe sequence used to calculate the value of a complex formula--multiplication and division before addition and subtraction.
Precedent cellsWorksheet cells that provide data to a formula.
Adjacent cellsCells that are located beside each other--either across or up and down.
Relative cell addressA cell reference that is adjusted when the formula is copied or moved to a new location.


Mrs. Arnold

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities