Mathematics > EXAMs > WGU C268 Spreadsheets: Final OA Study Guide 2022 solved Exam (All)

WGU C268 Spreadsheets: Final OA Study Guide 2022 solved Exam

Document Content and Description Below

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 cel ... ls 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() 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() Calculates the standard deviation for a sample. (Use STDEV.P to calculate the standard deviation for a population.) - ANSWER STDEV.S() The confidence interval or range of values that we believe the "true" population value falls into - ANSWER CONFIDENCE.NORM() Calculates the correlation coefficient between two sets of values - ANSWER CORREL() Calculates, or predicts, a future value along a linear trend by using existing values - ANSWER FORECAST() ^^ How to calculate payment amount for a loan - ANSWER In the cell next to the word payment enter: =PMT(rate [select the field with the interest rate]/12 [you put /12 because its monthly and there are 12 months in a year], nper [select the field with the term], pv [select the field with the principal value] - this will produce the results Example: =PMT(C13/12, C12, C11) [Show More]

Last updated: 3 years ago

Preview 1 out of 5 pages

Buy Now

Instant download

We Accept: