Google Sheets Flashcard 3

Front

What function should Jane use in Excel to add only the cells in a range that are greater than 1,000?

Back

SUMIF

Front

What function should Jamal use in Excel to average only the cells in a range that are greater than 100 but less than 500?

Back

AVERAGEIFS

Front

Jill wants to search her spreadsheet for a value in the first column of her table. What function should she use?

Back

VLOOKUP

Front

SUMIF and SUMIFS are in which category of functions?

Back

Math & Trig

Front

IF, AND, OR and NOT are all part of which category of functions?

Back

Logical

Front

Maggie wants to use a function that will return True when all its arguments are true, and False when one or more arguments are false. What function would she use?

Back

AND

Front

What function should Jane use to count only the cells in a range that contain 100?

Back

COUNTIF

Front

James wants his spreadsheet to return true when the logical value is false. What function should he use? Options: IF, AND, OR, NOT

Back

NOT

Front

Jill would like to use a function that will return "True" when only one of the arguments in the function is true. What function should she use?

Back

OR