Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
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?
Review
RAND BETWEEN(1000,5000)
Lower
AND
Proper
Tracking Changes
AVERAGEIFS
HLOOKUP
Which ribbon contains commands to add a comment about a selected cell in a worksheet?
Review
RAND BETWEEN(1000,5000)
Lower
AND
Proper
Tracking Changes
AVERAGEIFS
HLOOKUP
Maggie wants to use a function that will return True when all its arguments are true, and False when one or more arguments are false. What function would she use?
Review
RAND BETWEEN(1000,5000)
Lower
AND
Proper
Tracking Changes
AVERAGEIFS
HLOOKUP
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?
Review
RAND BETWEEN(1000,5000)
Lower
AND
Proper
Tracking Changes
AVERAGEIFS
HLOOKUP
Tom wants to convert all text to lowercase. Which function she he use?
Review
RAND BETWEEN(1000,5000)
Lower
AND
Proper
Tracking Changes
AVERAGEIFS
HLOOKUP
The FBLA Advisor at your school would like to create random ID numbers for FBLA members at your school. Which function would allow her to have Excel pick a random number between 1000 and 5000 for the new member ID numbers?
Review
RAND BETWEEN(1000,5000)
Lower
AND
Proper
Tracking Changes
AVERAGEIFS
HLOOKUP
Jessica needs to capitalize the first letter in each word. Which function would she use?
Review
RAND BETWEEN(1000,5000)
Lower
AND
Proper
Tracking Changes
AVERAGEIFS
HLOOKUP
Tom wants to search his spreadsheet for a value in the fourth row of his table. What function should he use?
Review
RAND BETWEEN(1000,5000)
Lower
AND
Proper
Tracking Changes
AVERAGEIFS
HLOOKUP
Check it!