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 represention of your worksheet data.
|
|
Complex Formulas
|
Formulas containing more then 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 reference.
|
|
Operand
|
A number 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 Reference
|
When the formula is copied to another cell, the cell will be adjusted relative to the formula's new location.
|
|
Statistical functions
|
Functions that describe large quantities of data.
|