Jane wants to add a range of cells in her spreadsheet. She would like Excel to add only the cells in that range that are greater than 1,000. What function should she use?

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?

Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should she use?

James wants his spreadsheet to return true when the logical value is false. What function should he use?

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

Jamal wants to average a range of cells in his spreadsheet. He would like Excel to average only the cells in that range that are greater than 100 but less than 500. What function should he use?

Tom wants to search his spreadsheet for a value in the fourth row of his table. What function should he use?

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?

In Sam’s spreadsheet, Column A has student first and last names. They need to be separated into two different columns. Which tool would he use?

Tom wants to convert all text to lowercase. Which function should he use?

Jessica needs to capitalize the first letter in each word. Which function would she use?

Elizabeth needs to convert all text in Column A to uppercase. Which function should she use?

SUMIF and SUMIFS are in which category of functions?