CA Excel Unit 6
Home > Flashcards > Print Preview
The flashcards below were created by user
adamwitkow
on
FreezingBlue Flashcards. What would you like to do?

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 preconstructed 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: