Spreadsheets C268: Final OA Latest Review

Spreadsheets C268: Final OA 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() 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 mid