# Excel Lesson 10

## Quiz by Lisa DeCastillia

### Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

15 questions
• Q1
Sheila 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?
Countif
Averageif
Totalif
Sumif
45s
• Q2
Beth needs to convert all text in Column A to uppercase. Which function should she use?
Lower
Trim
Upper
Proper
45s
• Q3
Martha wants to search her spreadsheet for a value in the first column of her table. What function should she use?
Vlookup
Lookup
Hlookup
Search
45s
• Q4
Rick 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?
Averageifs
Totalifs
Countifs
Sumifs
45s
• Q5
IF, AND, OR and NOT are all part of which category of functions?
Text
Logical
Math & Trig
Lookup & Reference
45s
• Q6
Pam 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?
Or
Not
And
If
45s
• Q7
Anna needs to capitalize the first letter in each word. Which function would she use?
Lower
Upper
Trim
Proper
45s
• Q8
Kevin wants to convert all text to lowercase. Which function should he use?
Lower
Upper
Proper
Trim
45s
• Q9
Frank wants his spreadsheet to return true when the logical value is false. What function should he use?
Or
And
Not
If
45s
• Q10
Robert wants to search his spreadsheet for a value in the fourth row of his table. What function should he use?
Vlookup
Lookup
Search
Hlookup
45s
• Q11
Sara 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 he use?
Countif
Sumif
Averageif
Totalif
45s
• Q12
In Rays's spreadsheet, Column A has student first and last names. They need to be separated into two different columns. Which tool would he use?
Convert text to column wizard
View side by side
Split view
Comma delimited
45s
• Q13
Seth wants to use an advanced function to search his spreadsheet for a specific string in a text string?
Vlookup
Find
Substitute
Search
45s
• Q14
Jeff wants to replace a specific text in a text string in his spreadsheet. What function should he use?
Find
Substitute
Search
Vlookup
45s
• Q15
SUMIF and SUMIFS are in which category of functions?
Text
Math & Trig
Logical
Lookup & Reference
45s

Teachers give this quiz to your class