MS Excel Honors #9

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

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?

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?

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

As the manager of a furniture store, Sally is using an Excel spreadsheet to keep track of the store sales goals. She wants to use a function that will return TRUE if at least one of the two goals is reached. Which 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?

Naming ranges or an individual cell is a time-saving technique. Range names may include a letter, an underscore, and: