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?
What is Averageifs
100
Elizabeth needs to convert all text in Column A to uppercase. Which function should she use?
What is Upper
100
A range of cells in a worksheet that contains related data
and can be used by a lookup function
What is table
200
Tom wants to convert all text to lowercase. Which function she he use?
What is Lower
200
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?
What is SUMIF
200
A condition you specify to limit which records are
returned when filtering data. The plural of criterion is criteria
What is criteria
300
Peter wants to replace a specific text in a text string in his spreadsheet. What function should he use?
What is SUBSTITUTE
300
IF, AND, OR and NOT are all part of which category of functions?
What is Logical
300
A formula in which the result is
determined by the presence or absence of a particular condition
What is conditional formula
400
SUMIF and SUMIFS are in which category of functions?
What is Math & Trig
400
The values a function uses to perform operations or
calculations in a formula
What is arguments
500
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?
What is AND
500
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?
What is Convert Text to Column Wizard
500
An efficient way to search for and insert a
value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook