CA Excel Unit 6

performs mathematical operations that produce a calculated result.

a typical cell reference that changes when copied.

indicated by dollar signs before the column letter and row number, stays the same regardless of where the formula is copied.

combines an absolute reference with a relative 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
argument list.

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
answers.

calculates the payment of a loan.

returns the future value of an investment.