CA Excel Unit 6
Home > Preview
The flashcards below were created by user
on FreezingBlue Flashcards.
performs mathematical operations that produce a calculated result.
a typical cell reference that changes when copied.
Reative cell reference:
indicated by dollar signs before the column letter and row number, stays the same regardless of where the formula is copied.
Absolute cell reference:
combines an absolute reference with a relative reference.
Mixed cell reference:
is a pre-constructed formula that makes difficult computations less complicated.
refers to the rules for constructing the function.
values as input that perform an indicated calculation, and then return another value as output.
calculates the arithmetic mean, or average, for the values in an
determines the smallest value of all cells in a list of arguments.
determines the highest value of all cells in a list of arguments.
counts the number of cells in a range that contain numerical data.
counts the number of cells in a range that are not blank.
finds the mid point value in a set of values.
displays the current date in a cell
uses the computer’s clock to display the current date and time side by
side in a cell.
returns one value when a condition is met and returns another value when
the condition is not met.
looks up an answer from a vertical table of possible
calculates the payment of a loan.
returns the future value of an investment.
Home > Flashcards > Print Preview