Information Technology > QUESTIONS & ANSWERS > WGU SPREADSHEETS C268: FINAL OA STUDY GUIDE QUESTIONS WITH COMPLETE SOLUTIONS (All)

WGU SPREADSHEETS C268: FINAL OA STUDY GUIDE QUESTIONS WITH COMPLETE SOLUTIONS

Document Content and Description Below

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() [Show More]

Last updated: 2 years ago

Preview 1 out of 5 pages

Buy Now

Instant download

We Accept: