Excel 2016 - Lesson 10

James wants to use an advanced function to search his spreadsheet for a specific string in a text string. What function should he use?

• FIND

• SUBSTITUTE

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

• OR

• NOT

SUMIF and SUMIFS are in which category of functions?

• Math & Trig

• Logical

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

• Upper

• Proper

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

• VLOOKUP

• LOOKUP

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?

• AVERAGEIF

• COUNTIF

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?

• Convert Text to Column Wizard

• Comma Delimited

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

• Math & Trig

• Logical

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?

• SUMIFS

• AVERAGEIFS

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

• LOOKUP

• HLOOKUP