Review Game Zone
Games
Test
Preview
Back
Match it!
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?
UPPER
NOW
AVERAGEIFS
Statistical
C2:C50
TODAY
Name Manager
HLOOKUP
Larry has created a spreadsheet containing student grades. Which function would he use to return the current date in cell A1?
UPPER
NOW
AVERAGEIFS
Statistical
C2:C50
TODAY
Name Manager
HLOOKUP
Tyrone would like to use a function that returns a value that meets criteria in the second row of a table in his spreadsheet. Which function should he use?
UPPER
NOW
AVERAGEIFS
Statistical
C2:C50
TODAY
Name Manager
HLOOKUP
Elizabeth needs to convert all text in Column A to uppercase. Which function should she use?
UPPER
NOW
AVERAGEIFS
Statistical
C2:C50
TODAY
Name Manager
HLOOKUP
Larry has created a spreadsheet containing student grades. Which function would he use to return the current date and time in cell A1?
UPPER
NOW
AVERAGEIFS
Statistical
C2:C50
TODAY
Name Manager
HLOOKUP
AVERAGEIFS, COUNTIFS, and GROWTH are found in which category of functions?
UPPER
NOW
AVERAGEIFS
Statistical
C2:C50
TODAY
Name Manager
HLOOKUP
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?
UPPER
NOW
AVERAGEIFS
Statistical
C2:C50
TODAY
Name Manager
HLOOKUP
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?
UPPER
NOW
AVERAGEIFS
Statistical
C2:C50
TODAY
Name Manager
HLOOKUP
Check it!