# WGU C268 Spreadsheets Final OA Study Guide

.pdf
WGU C268 Spreadsheets Final OA Study Guide Questions and Answers Already Graded 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() 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() Returns the related value from the specified row after finding the match in the first row ✔✔ HLOOKUP() The length, in number of characters, of a block of text ✔✔ LEN() The position of a specific character, word, or phrase within a block of text ✔✔ SEARCH() Returns the specified number of characters starting from the beginning of a block of text ✔✔ LEFT() Returns the specified number of characters from the middle of a block of text ✔✔ MID() Returns the specified number of characters starting from the end of a block of text ✔✔ RIGHT() Combines blocks of text ✔✔ CONCATENATE()