WGU C268 Spreadsheets C268: Final OA Study Guide with complete solution

WGU C268 Spreadsheets C268: Final OA

Study Guide

Adds the individual numbers or the numbers included in the range(s). Correct answerSUM()

Counts the number of cells in a range of cells that contain numbers. Correct answerCOUNT()

Counts the number of cells in a range of cells that are not blank Correct answerCOUNTA()

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 answerNPER()

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 answerAVERAGEIF()

Returns the related value from the specified column after finding the match in the first

column Correct answer- VLOOKUP()

Returns the related value from the specified row after finding the match in the first row

Correct answer- HLOOKUP()

The length, in number of characters, of a block of text Correct answer- LEN()

The position of a specific character, word, or phrase within a block of text Correct

answer- SEARCH()

Returns the specified number of characters starting from the beginning of a block of text

Correct answer- LEFT()

Returns the specified number of characters from the middle of a block of text Correct

answer- MID()

Returns the specified number of characters starting from the end of a block of text

Correct answer- RIGHT()

Combines blocks of text Correct answer- CONCATENATE()

Calculates the standard deviation for a sample. (Use STDEV.P to calculate the standard

deviation for a population.) Correct answer- STDEV.S()

The confidence interval or range of values that we believe the "true" population value

falls into Correct answer- CONFIDENCE.NORM()

Calculates the correlation coefficient between two sets of values Correct answerCORREL()

Calculates, or predicts, a future value along a linear trend by using existing values

Correct answer- FORECAST()