WGU C268 FINAL OA EXAM 100 QUESTIONS
AND CORRECT ANSWERS|AGRADE (COMPLETE
EXAM)
Adds the individual numbers or the numbers included in the range(s). - ANSWER- SUM()
Counts the number of cells in a range of cells that contain numbers. - ANSWER-
COUNT()
Counts the number of cells in a range of cells that are not blank - ANSWER-
COUNTA()
Calculates the simple average of a set of numbers - ANSWER- AVERAGE()
Returns the largest value in a set of numbers - ANSWER- MAX()
Returns the smallest value in a set of numbers - ANSWER- MIN()
Calculates the interest rate earned for an investment - ANSWER- RATE()
Calculates the annual percentage rate for an interest rate - ANSWER- EFFECT()
Calculates the number of payments that will be made to pay off a loan -
ANSWER- NPER()
Calculates the payment amount for a loan - ANSWER- PMT()
Calculates the current value of an investment (accounting for compound interest) -
ANSWER- PV()
Calculates the future value of an investment - ANSWER- FV()
Combines Boolean expressions to determine if ALL of the combined expressions are TRUE - ANSWER- AND()
- / 2
Combines Boolean expressions to determine if ANY of the combined expressions are TRUE - ANSWER- OR()
Check to see if a Boolean expression is not evaluated as TRUE - ANSWER- NOT()
Build on Boolean logic and specify the results depending on the results of the Boolean expression - ANSWER- IF()
Determine (count) the number of cells within a range of cells that contain a specific value - ANSWER- COUNTIF()
Calculate the total (sum) for a set of values that match a specific criterion -
ANSWER- SUMIF()
Calculate the average for a set of values that match a specific criterion -
ANSWER- AVERAGEIF()
Returns the related value from the specified column after finding the match in the first column - ANSWER- VLOOKUP()
Returns the related value from the specified row after finding the match in the first row - ANSWER- HLOOKUP()
The length, in number of characters, of a block of text - ANSWER- LEN()
The position of a specific character, word, or phrase within a block of text -
ANSWER- SEARCH()
Returns the specified number of characters starting from the beginning of a block of text - ANSWER- LEFT()
Returns the specified number of characters from the middle of a block of text -
ANSWER- MID()
Returns the specified number of characters starting from the end of a block of text -
ANSWER- RIGHT()
Combines blocks of text - ANSWER- CONCATENATE()
- / 2