Spreadsheets C268: Flash Cards w/ Images Exam Questions with Answers

Spreadsheets C268: Flash Cards w/
Images Exam Questions with
Answers
Adds the individual numbers or the numbers included in the range(s). - -
SUM()

- Counts the number of cells in a range of cells that contain numbers. - -
COUNT()

- Counts the number of cells in a range of cells that are not blank - -
COUNTA()

- Calculates the simple average of a set of numbers - -AVERAGE()

- Returns the largest value in a set of numbers - -MAX()

- Returns the smallest value in a set of numbers - -MIN()

- Calculates the interest rate earned for an investment - -RATE()

- Calculates the annual percentage rate for an interest rate - -EFFECT()

- Calculates the number of payments that will be made to pay off a loan - -
NPER()

- Calculates the payment amount for a loan - -PMT()

- Calculates the current value of an investment (accounting for compound
interest) - -PV()

- Calculates the future value of an investment - -FV()

- Combines Boolean expressions to determine if ALL of the combined
expressions are TRUE - -AND()

- Combines Boolean expressions to determine if ANY of the combined
expressions are TRUE - -OR()

- Check to see if a Boolean expression is not evaluated as TRUE - -NOT()

- Build on Boolean logic and specify the results depending on the results of
the Boolean expression - -IF()