C268 WGU SPREADSHEETS: FLASH CARDS W/
IMAGES
Adds the individual numbers or the numbers included in the range(s). - Answers -
SUM()
Counts the number of cells in a range of cells that contain numbers. - Answers -
COUNT()
Counts the number of cells in a range of cells that are not blank - Answers - COUNTA()
Calculates the simple average of a set of numbers - Answers - AVERAGE()
, Returns the largest value in a set of numbers - Answers - MAX()
Returns the smallest value in a set of numbers - Answers - MIN()
Calculates the interest rate earned for an investment - Answers - RATE()
Calculates the annual percentage rate for an interest rate - Answers - EFFECT()
IMAGES
Adds the individual numbers or the numbers included in the range(s). - Answers -
SUM()
Counts the number of cells in a range of cells that contain numbers. - Answers -
COUNT()
Counts the number of cells in a range of cells that are not blank - Answers - COUNTA()
Calculates the simple average of a set of numbers - Answers - AVERAGE()
, Returns the largest value in a set of numbers - Answers - MAX()
Returns the smallest value in a set of numbers - Answers - MIN()
Calculates the interest rate earned for an investment - Answers - RATE()
Calculates the annual percentage rate for an interest rate - Answers - EFFECT()