# Excel Lesson 10

## Quiz by Lisa DeCastillia

Feel free to use or edit a copy

includes Teacher and Student dashboards

### Measure skillsfrom any curriculum

Measure skills

from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can

- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet

15 questions

Show answers

- Q1Sheila 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?CountifAverageifTotalifSumif45s
- Q2Beth needs to convert all text in Column A to uppercase. Which function should she use?LowerTrimUpperProper45s
- Q3Martha wants to search her spreadsheet for a value in the first column of her table. What function should she use?VlookupLookupHlookupSearch45s
- Q4Rick 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?AverageifsTotalifsCountifsSumifs45s
- Q5IF, AND, OR and NOT are all part of which category of functions?TextLogicalMath & TrigLookup & Reference45s
- Q6Pam 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?OrNotAndIf45s
- Q7Anna needs to capitalize the first letter in each word. Which function would she use?LowerUpperTrimProper45s
- Q8Kevin wants to convert all text to lowercase. Which function should he use?LowerUpperProperTrim45s
- Q9Frank wants his spreadsheet to return true when the logical value is false. What function should he use?OrAndNotIf45s
- Q10Robert wants to search his spreadsheet for a value in the fourth row of his table. What function should he use?VlookupLookupSearchHlookup45s
- Q11Sara 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?CountifSumifAverageifTotalif45s
- Q12In 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 wizardView side by sideSplit viewComma delimited45s
- Q13Seth wants to use an advanced function to search his spreadsheet for a specific string in a text string?VlookupFindSubstituteSearch45s
- Q14Jeff wants to replace a specific text in a text string in his spreadsheet. What function should he use?FindSubstituteSearchVlookup45s
- Q15SUMIF and SUMIFS are in which category of functions?TextMath & TrigLogicalLookup & Reference45s