WGU C268 Spreadsheets C268: Final OA Study Guide with complete solution
WGU C268 Spreadsheets C268: Final OA Study Guide with complete solution WGU C268 Spreadsheets C268: Final OA Study Guide with complete solution 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()
Document information
- Uploaded on
- November 16, 2022
- Number of pages
- 5
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers