WGU C268 Spreadsheets: Final OA
Study Guide 2022 solved Exam
Adds the individual numbers or the numbers included in the range(s). - ANSWER
SUM()
Counts the number of cells in a range of cells that contain numbers. - ANSWER
COUNT()
Counts the number of cells in a range of cells that are not blank - ANSWER COUNTA()
Calculates the simple average of a set of numbers - ANSWER AVERAGE()
Returns the largest value in a set of numbers - ANSWER MAX()
Returns the smallest value in a set of numbers - ANSWER MIN()
Calculates the interest rate earned for an investment - ANSWER RATE()
Calculates the annual percentage rate for an interest rate - ANSWER EFFECT()
Calculates the number of payments that will be made to pay off a loan - ANSWER
NPER()
Calculates the payment amount for a loan - ANSWER PMT()
Calculates the current value of an investment (accounting for compound interest) -
ANSWER PV()
Calculates the future value of an investment - ANSWER FV()
Combines Boolean expressions to determine if ALL of the combined expressions are
TRUE - ANSWER AND()
Combines Boolean expressions to determine if ANY of the combined expressions are
TRUE - ANSWER OR()
Check to see if a Boolean expression is not evaluated as TRUE - ANSWER NOT()
Build on Boolean logic and specify the results depending on the results of the Boolean
expression - ANSWER IF()
Determine (count) the number of cells within a range of cells that contain a specific
value - ANSWER COUNTIF()
, Calculate the total (sum) for a set of values that match a specific criterion - ANSWER
SUMIF()
Calculate the average for a set of values that match a specific criterion - ANSWER
AVERAGEIF()
Returns the related value from the specified column after finding the match in the first
column - ANSWER VLOOKUP()
Returns the related value from the specified row after finding the match in the first row -
ANSWER HLOOKUP()
The length, in number of characters, of a block of text - ANSWER LEN()
The position of a specific character, word, or phrase within a block of text - ANSWER
SEARCH()
Returns the specified number of characters starting from the beginning of a block of text
- ANSWER LEFT()
Returns the specified number of characters from the middle of a block of text -
ANSWER MID()
Returns the specified number of characters starting from the end of a block of text -
ANSWER RIGHT()
Combines blocks of text - ANSWER CONCATENATE()
Calculates the standard deviation for a sample. (Use STDEV.P to calculate the standard
deviation for a population.) - ANSWER STDEV.S()
The confidence interval or range of values that we believe the "true" population value
falls into - ANSWER CONFIDENCE.NORM()
Calculates the correlation coefficient between two sets of values - ANSWER CORREL()
Calculates, or predicts, a future value along a linear trend by using existing values -
ANSWER FORECAST()
^^ How to calculate payment amount for a loan - ANSWER In the cell next to the word
payment enter: =PMT(rate [select the field with the interest rate]/12 [you put /12
because its monthly and there are 12 months in a year], nper [select the field with the
term], pv [select the field with the principal value] - this will produce the results
Example: =PMT(C13/12, C12, C11)
Study Guide 2022 solved Exam
Adds the individual numbers or the numbers included in the range(s). - ANSWER
SUM()
Counts the number of cells in a range of cells that contain numbers. - ANSWER
COUNT()
Counts the number of cells in a range of cells that are not blank - ANSWER COUNTA()
Calculates the simple average of a set of numbers - ANSWER AVERAGE()
Returns the largest value in a set of numbers - ANSWER MAX()
Returns the smallest value in a set of numbers - ANSWER MIN()
Calculates the interest rate earned for an investment - ANSWER RATE()
Calculates the annual percentage rate for an interest rate - ANSWER EFFECT()
Calculates the number of payments that will be made to pay off a loan - ANSWER
NPER()
Calculates the payment amount for a loan - ANSWER PMT()
Calculates the current value of an investment (accounting for compound interest) -
ANSWER PV()
Calculates the future value of an investment - ANSWER FV()
Combines Boolean expressions to determine if ALL of the combined expressions are
TRUE - ANSWER AND()
Combines Boolean expressions to determine if ANY of the combined expressions are
TRUE - ANSWER OR()
Check to see if a Boolean expression is not evaluated as TRUE - ANSWER NOT()
Build on Boolean logic and specify the results depending on the results of the Boolean
expression - ANSWER IF()
Determine (count) the number of cells within a range of cells that contain a specific
value - ANSWER COUNTIF()
, Calculate the total (sum) for a set of values that match a specific criterion - ANSWER
SUMIF()
Calculate the average for a set of values that match a specific criterion - ANSWER
AVERAGEIF()
Returns the related value from the specified column after finding the match in the first
column - ANSWER VLOOKUP()
Returns the related value from the specified row after finding the match in the first row -
ANSWER HLOOKUP()
The length, in number of characters, of a block of text - ANSWER LEN()
The position of a specific character, word, or phrase within a block of text - ANSWER
SEARCH()
Returns the specified number of characters starting from the beginning of a block of text
- ANSWER LEFT()
Returns the specified number of characters from the middle of a block of text -
ANSWER MID()
Returns the specified number of characters starting from the end of a block of text -
ANSWER RIGHT()
Combines blocks of text - ANSWER CONCATENATE()
Calculates the standard deviation for a sample. (Use STDEV.P to calculate the standard
deviation for a population.) - ANSWER STDEV.S()
The confidence interval or range of values that we believe the "true" population value
falls into - ANSWER CONFIDENCE.NORM()
Calculates the correlation coefficient between two sets of values - ANSWER CORREL()
Calculates, or predicts, a future value along a linear trend by using existing values -
ANSWER FORECAST()
^^ How to calculate payment amount for a loan - ANSWER In the cell next to the word
payment enter: =PMT(rate [select the field with the interest rate]/12 [you put /12
because its monthly and there are 12 months in a year], nper [select the field with the
term], pv [select the field with the principal value] - this will produce the results
Example: =PMT(C13/12, C12, C11)
