WGU C268 SPREADSHEETS OA QUESTIONS AND ANSWERS 2024

WGU C268 SPREADSHEETS OA


Calculates the interest rate earned for an investment - ANSWERS-RATE()



Calculates the annual percentage rate for an interest rate - ANSWERS-EFFECT()



Calculates the number of payments that will be made to pay off a loan -
ANSWERS-NPER()



Calculates the payment amount for a loan - ANSWERS-PMT()



Calculates the current value of an investment (accounting for compound interest)
- ANSWERS-PV()



Calculates the future value of an investment - ANSWERS-FV()



Combines Boolean expressions to determine if ALL of the combined expressions
are TRUE - ANSWERS-AND()



Combines Boolean expressions to determine if ANY of the combined expressions
are TRUE - ANSWERS-OR()

, Check to see if a Boolean expression is not evaluated as TRUE - ANSWERS-NOT()



Build on Boolean logic and specify the results depending on the results of the
Boolean expression - ANSWERS-IF()



Determine (count) the number of cells within a range of cells that contain a
specific value - ANSWERS-COUNTIF()




Adds the individual numbers or the numbers included in the range(s). - ANSWERS-
SUM()



Counts the number of cells in a range of cells that contain numbers. - ANSWERS-
COUNT()



Counts the number of cells in a range of cells that are not blank - ANSWERS-
COUNTA()



Calculates the simple average of a set of numbers - ANSWERS-AVERAGE()



Returns the largest value in a set of numbers - ANSWERS-MAX()



Returns the smallest value in a set of numbers - ANSWERS-MIN()