Excel Lesson 10 Pt.2

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

• VLOOKUP
• HLOOKUP
• LOOKUP
• SEARCH

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?

• SUMIF
• AVERAGEIF
• TOTALIF
• COUNTIF

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

• Math & Trig
• Text
• Logical
• Lookup & Reference

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?

• IF
• AND
• OR
• NOT

Tom wants to convert all text to lowercase. Which function should he 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

SUMIF and SUMIFS are in which category of functions?

• Math & Trig
• Text
• Logical
• Lookup & Reference

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
• Split View
• View Side-by-Side
• Comma Delimited