Excel 1.10-1.11 (Part 2)

Match it! Select the correct answer from the pull down...Good luck!

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?

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

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

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?

Lilly is creating a spreadsheet for FBLA and would like to see the changes advisors have made to the workbook. What command allows her to do this?

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

Which ribbon contains commands to add a comment about a selected cell in a worksheet?

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