Spreadsheets WGU C268: Final OA Study Guide

Spreadsheets C268: Final OA Study Guide
Adds the individual numbers or the numbers included in the range(s). Correct Answer: SUM()

Counts the number of cells in a range of cells that contain numbers. Correct Answer: COUNT()

Counts the number of cells in a range of cells that are not blank Correct Answer: COUNTA()

Calculates the simple average of a set of numbers Correct Answer: AVERAGE()

Returns the largest value in a set of numbers Correct Answer: MAX()

Returns the smallest value in a set of numbers Correct Answer: MIN()

Calculates the interest rate earned for an investment Correct Answer: RATE()

Calculates the annual percentage rate for an interest rate Correct Answer: EFFECT()

Calculates the number of payments that will be made to pay off a loan Correct Answer: NPER()

Calculates the payment amount for a loan Correct Answer: PMT()

Calculates the current value of an investment (accounting for compound interest) Correct Answer: PV()

Calculates the future value of an investment Correct Answer: FV()

Combines Boolean expressions to determine if ALL of the combined expressions are TRUE Correct
Answer: AND()

Combines Boolean expressions to determine if ANY of the combined expressions are TRUE Correct
Answer: OR()

Check to see if a Boolean expression is not evaluated as TRUE Correct Answer: NOT()

Build on Boolean logic and specify the results depending on the results of the Boolean expression
Correct Answer: IF()

Determine (count) the number of cells within a range of cells that contain a specific value Correct
Answer: COUNTIF()

Calculate the total (sum) for a set of values that match a specific criterion Correct Answer: SUMIF()

Calculate the average for a set of values that match a specific criterion Correct Answer: AVERAGEIF()

Returns the related value from the specified column after finding the match in the first column Correct
Answer: VLOOKUP()