# CA Excel Unit 6

 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: Authoradamwitkow ID22871 Card SetCA Excel Unit 6 DescriptionCA Excel Unit 6 Updated2010-06-09T23:59:17Z Show Answers