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
|
A refernce that 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; it is enclosed in pararenthesis after the function name
|
|
chart
|
A graphic representation of worksheet or table data
|
|
Complex formulas
|
Excel formulas containing more than one operator
|
|
Embedded chart
|
A chart created on the same sheet as the data used in the chart
|
|
Formula
|
Equations using numbers and cell references to perform calculations such as addition, subtraction, multiplication, and division
|
|
Function formula
|
A special formula that names a function instead of using operators to calculate a formula
|
|
Mathematical functions
|
perform calculations that you can do using a scientific calculator
|
|
Mixed cell reference
|
A cell referece that contains both relative and absolute references
|
|
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 the value of the formula
|
|
Relative cell references
|
Cell references that which will be adjusted relative to the formulas new location when a formula is copied or moved
|
|
Statistical functions
|
Functions that describe large quanities of data
|