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;
14 Cards in this Set
- Front
- Back
Absolute Cell Reference
|
does not change when the formula is copied or moved to a new location
|
|
Argument
|
a value, a cell reference, a range, or text that acts as an operand in a function formula, and it is enclosed in parentheses after the function name
|
|
Chart
|
a graphic representation of your worksheet data
|
|
Complex Formulas
|
formulas containing more than one operator
|
|
Embedded Chart
|
a chart created on the same sheet as the data used in the chart
|
|
Formula
|
the equation used to calculate values in a cell
|
|
Function Formula
|
a special formula that names a function instead of using operators to calculate a result
|
|
Mathematical Functions
|
perform calculations that you could perform using a scientific calculator
|
|
Mixed Cell Reference
|
a cell reference that contains both relative and absolute references
|
|
Operand
|
a number cell or cell reference
|
|
Operator
|
a symbol that indicates the mathematical operation to perform with the operands
|
|
Order of Evaluation
|
the sequence used to calculate the value of a formula
|
|
Relative Cell References
|
when the formula is copied to another cell, the cell references will be adjusted relative to the formula's new location
|
|
Statistical Functions
|
functions that describe large quantities of data
|