Excel Lesson 10-11 Review

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

• Trim

• Proper

• Upper

• Lower

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 IF the cells in that range that are greater than 1,000. What function should she use?

• SUMIF

• AVERAGEIF

• TOTALIF

• 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

• Split View

• View Side-by-Side

• Comma Delimited

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

• SUMIF

• AVERAGEIF

• TOTALIF

• COUNTIF

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

• Trim

• Proper

• Upper

• Lower

What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook?

• Protect Workbook

• Share

• Protect Sheet

• Protection

Where is the spell checker feature located in Microsoft Excel?

• Home Ribbon

• Page Layout Ribbon

• Review Ribbon

• View Ribbon

Which function would be used to have Excel pick a random number between 1,000 and 5,000 for the new member ID

numbers?

• RAND()

• RANDBETWEEN(1000,5000)

• BETWEEN(1000,5000)

• RANDOM(1000,5000)

Which command allows users to add a new comment informing other people of important information on a sheet?

• New

• Delete

• Edit Comment

• Show Ink