WGU C268 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() 1 / 2
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() 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 answer-
CORREL()
Calculates, or predicts, a future value along a linear trend by using existing values Correct answer- FORECAST()
- / 2