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 reference that does not change when the formula is copied or moved to anew location
|
|
argument
|
a value, a cell reference, a range, or text that acts as an operand in a function formula; it is enclosed in parenthesis after the function name
|
|
chart
|
a graphic representation of worksheet or table data
|
|
complex formulas
|
excel formulas containing more than one operator
|
|
embedded charts
|
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 could do 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 evalutation
|
the sequence used to calculate the value of a formula
|
|
relative cell references
|
cell references which will be adjusted relative to the formulas new location when a formula is copied or moved into a new location
|
|
statistical functions
|
functions that describe large quantities of data
|