- / 5
WGU C268 Spreadsheets Final OA Study Guide
1.Adds the individual numbers or the numbers included in the range(s).: -
SUM()
2.Counts the number of cells in a range of cells that contain numbers.: -
COUNT()
3.Counts the number of cells in a range of cells that are not blank:
COUNTA()
4.Calculates the simple average of a set of numbers: AVERAGE()
5.Returns the largest value in a set of numbers: MAX()
6.Returns the smallest value in a set of numbers: MIN()
7.Calculates the interest rate earned for an investment: RATE()
8.Calculates the annual percentage rate for an interest rate: EFFECT()
9.Calculates the number of payments that will be made to pay off a loan: -
NPER()
10.Calculates the payment amount for a loan: PMT()
11.Calculates the current value of an investment (accounting for 1 / 2
- / 5
compound interest): PV()
12.Calculates the future value of an investment: FV()
13.Combines Boolean expressions to determine if ALL of the
combined expressions are TRUE: AND()
14.Combines Boolean expressions to determine if ANY of the
combined expressions are TRUE: OR()
15.Check to see if a Boolean expression is not evaluated as TRUE: NOT()
16.Build on Boolean logic and specify the results depending on the results
of the Boolean expression: IF()
17.Determine (count) the number of cells within a range of cells that
contain a specific value: COUNTIF()
18.Calculate the total (sum) for a set of values that match a specific
criteri- on: SUMIF()
19.Calculate the average for a set of values that match a specific criterion:
-
AVERAGEIF()
20.Returns the related value from the specified column after finding
the match in the first column: VLOOKUP()
- / 2