Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
15 Cards in this Set
- Front
- Back
Absolute cell reference
|
A cell reference that does not change when the formula is copied or moved
|
|
Argument
|
A value, cell reference, range, or text that acts as an operand in a function formula
|
|
Dependent cells
|
Worksheet formulas that reference a particular cell
|
|
Formulas
|
Equation used to calculate values in a spreadsheet cell
|
|
Function formula
|
A special formula that names a function instead of using operators to calculate a result
|
|
Mixed cell reference
|
A cell reference that contains both relative and absolute cell
references |
|
Operand
|
Number or ell reference in a formula
|
|
Operator
|
A symbol that tells Excel what mathematical operation to perform in a worksheet formula
|
|
Order of evaluation
|
The sequence used to calculate the value of a complex formula
|
|
Precedent cells
|
Worksheet cells that provide data to a formula
|
|
Relative cell references
|
A cell reference that is adjusted when the formula is copied or moved to a new location
|
|
Logical functions
|
Used to display text or values when certain conditions exist
|
|
Mathematical functions
|
Perform calculations that you could do using a scientific calculator
|
|
Statistical functions
|
Describe large quantities of data
|
|
Trigonometric functions
|
perform calculations that you could do usin a scientific calculator
|