Excel Functions--Unit E
Review of various functions in Microsoft Excel.
Calculates the future value of an investment using a constant interest rate and periodic, unvarying payments.
Displays TRUE when all arguments are true.
Displays different values based on whether a condition is true or false.
Will change FALSE to TRUE or TRUE to FALSE.
Displays TRUE when any argument is true.
Adds a range of data.
Identifies the highest number in a range of data.
Identifies the lowest number in a range of data.
Use constant payments and a constant interest rate to calculate payments for a loan.
Calculate the present value (NOT the net present value) of an investment.
Displays specified text if an argument contains an error and the value in the argument if the argument does not contain an error.
Averages the cells specified by a given condition or criteria.
Counts the number of cells specified by a given condition or criteria.
Adds the cells specified by a given condition or criteria.
Calculate the net present value of an investment based on a discount rate, a series of future payments, and income.
Displays the interest rate per period of a loan or an investment.
Converts text to all uppercase letters.
Converts text to all lowercase letters.
Joins two or more strings into one text string.
Capitalizes the first letter in a string of text as well as any text following a space.