WGU C268 Spreadsheets: Final OA
Study Guide 100% Correct
Adds the individual numbers or the numbers included in the range(s). ✔✔SUM()
Counts the number of cells in a range of cells that contain numbers. ✔✔COUNT()
Counts the number of cells in a range of cells that are not blank ✔✔COUNTA()
Calculates the simple average of a set of numbers ✔✔AVERAGE()
Returns the largest value in a set of numbers ✔✔MAX()
Returns the smallest value in a set of numbers ✔✔MIN()
Calculates the interest rate earned for an investment ✔✔RATE()
Calculates the annual percentage rate for an interest rate ✔✔EFFECT() 1 / 2
Calculates the number of payments that will be made to pay off a loan ✔✔NPER()
Calculates the payment amount for a loan ✔✔PMT()
Calculates the current value of an investment (accounting for compound interest) ✔✔PV()
Calculates the future value of an investment ✔✔FV()
Combines Boolean expressions to determine if ALL of the combined expressions are TRUE
✔✔AND()
Combines Boolean expressions to determine if ANY of the combined expressions are TRUE
✔✔OR()
Check to see if a Boolean expression is not evaluated as TRUE ✔✔NOT()
- / 2