Home
Flashcards
Preview
CA Excel Unit 6
Home
Get App
Take Quiz
Create
performs mathematical operations that produce a calculated result.
Formula:
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.
Function:
refers to the rules for constructing the function.
Syntax:
values as input that perform an indicated calculation, and then return another value as output.
Arguments:
calculates the arithmetic mean, or average, for the values in an
argument list.
AVERAGE function:
determines the smallest value of all cells in a list of arguments.
MIN function:
determines the highest value of all cells in a list of arguments.
MAX function:
counts the number of cells in a range that contain numerical data.
COUNT function:
counts the number of cells in a range that are not blank.
COUNTA function:
finds the mid point value in a set of values.
MEDIAN function:
displays the current date in a cell
TODAY function:
uses the computer’s clock to display the current date and time side by
side in a cell.
NOW function:
returns one value when a condition is met and returns another value when
the condition is not met.
IF function:
looks up an answer from a vertical table of possible
answers.
VLOOKUP function:
calculates the payment of a loan.
PMT function:
returns the future value of an investment.
FV function:
Author
adamwitkow
ID
22871
Card Set
CA Excel Unit 6
Description
CA Excel Unit 6
Updated
2010-06-09T23:59:17Z
Home
Flashcards
Preview