MS Excel Honors #9

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

Which is an example of a function that extracts the year from a date that is typed in cell B9?

Larry has created a spreadsheet containing student grades. Which function would he use to return the current date in cell A1?

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?

In order to change the name of a range of cells, the user must first click the Formulas tab. What feature should the user click next?

A spreadsheet contains 50 rows with pet records. Column A is Breed, column B is Name, and column C is Gender. To determine the number of animals that are female, what is the range when using the COUNTIF function?

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?

AVERAGEIFS, COUNTIFS, and GROWTH are found in which category of functions?

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