WGU C268 Spreadsheets C268 Final OA Study Guide
Adds the individual numbers or the numbers included in the range(s). - ANS-SUM()
Counts the number of cells in a range of cells that contain numbers. - ANS-COUNT()
Counts the number of cells in a range of cells that are not blank - ANS-COUNTA()
Calculates the simple average of a set of numbers - ANS-AVERAGE()
Returns the largest value in a set of numbers - ANS-MAX()
Returns the smallest value in a set of numbers - ANS-MIN()
Calculates the interest rate earned for an investment - ANS-RATE()
Calculates the annual percentage rate for an interest rate - ANS-EFFECT()
Calculates the number of payments that will be made to pay off a loan - ANS-NPER()
Calculates the payment amount for a loan - ANS-PMT()
Calculates the current value of an investment (accounting for compound interest) -
ANS-PV()
Calculates the future value of an investment - ANS-FV()
Combines Boolean expressions to determine if ALL of the combined expressions are
TRUE - ANS-AND()
Combines Boolean expressions to determine if ANY of the combined expressions are
TRUE - ANS-OR()
Check to see if a Boolean expression is not evaluated as TRUE - ANS-NOT()
Build on Boolean logic and specify the results depending on the results of the Boolean
expression - ANS-IF()
Determine (count) the number of cells within a range of cells that contain a specific
value - ANS-COUNTIF()
Calculate the total (sum) for a set of values that match a specific criterion - ANS-
SUMIF()
