20 terms

Excel Functions--Unit E

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