Excel Chapter 10

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

• VLOOKUP

• HLOOKUP

• LOOKUP

• SEARCH

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

• Trim

• Proper

• Upper

• Lower

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

• Trim

• Proper

• Upper

• Lower

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

• TOTALIFS

• COUNTIFS

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

• SEARCH

• VLOOKUP

• HLOOKUP

• LOOKUP

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

• FIND

• SUBSTITUTE

• VLOOKUP

• REPLACE

Peter wants to replace a specific text in a text string in his spreadsheet. What function should he use?

• FIND

• SUBSTITUTE

• VLOOKUP

• SEARCH

SUMIF and SUMIFS are in which category of functions?

• Math & Trig

• Text

• Logical

• Lookup & Reference

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 he use?

• SUMIF

• AVERAGEIF

• TOTALIF

• COUNTIF

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

• Trim

• Proper

• Upper

• Lower