WGU C268 Spreadsheets Final OA Study Guide Questions and Answers Already Graded A+

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