WGU C268 Spreadsheets C268, Final OA
Study Guide with complete solution
100%Verified Answers Latest Updated
2024 Absolute A+!!
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()
Calculates the number of payments that will be made to pay off a
loan - ✅✅NPER()
Calculates the payment amount for a loan - ✅✅PMT()
[Type here] [Type here] [Type here]
, WGU C268 Spreadsheets C268, Final OA
Study Guide with complete solution
100%Verified Answers Latest Updated
2024 Absolute A+!!
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()
Build on Boolean logic and specify the results depending on the
results of the Boolean expression - ✅✅IF()
Determine (count) the number of cells within a range of cells that
contain a specific value - ✅✅COUNTIF()
Calculate the total (sum) for a set of values that match a specific
criterion - ✅✅SUMIF()
Calculate the average for a set of values that match a specific
criterion - ✅✅AVERAGEIF()
Returns the related value from the specified column after finding
the match in the first column - ✅✅VLOOKUP()
[Type here] [Type here] [Type here]
Study Guide with complete solution
100%Verified Answers Latest Updated
2024 Absolute A+!!
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()
Calculates the number of payments that will be made to pay off a
loan - ✅✅NPER()
Calculates the payment amount for a loan - ✅✅PMT()
[Type here] [Type here] [Type here]
, WGU C268 Spreadsheets C268, Final OA
Study Guide with complete solution
100%Verified Answers Latest Updated
2024 Absolute A+!!
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()
Build on Boolean logic and specify the results depending on the
results of the Boolean expression - ✅✅IF()
Determine (count) the number of cells within a range of cells that
contain a specific value - ✅✅COUNTIF()
Calculate the total (sum) for a set of values that match a specific
criterion - ✅✅SUMIF()
Calculate the average for a set of values that match a specific
criterion - ✅✅AVERAGEIF()
Returns the related value from the specified column after finding
the match in the first column - ✅✅VLOOKUP()
[Type here] [Type here] [Type here]
