6. Sum if and averageif. greater than and less than.
Quiz by Matthew Morton-Banner
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
10 questions
Show answers
- Q1If we want to add up all the numbers in a list that are greater than 5 using Excel, which function could we use?PRODUCTSUMIFAVERAGEIFCOUNTIF30s
- Q2What function would you use to find the average of numbers that are less than 10 in Excel?AVERAGEIFCOUNTIFMINSUMIF30s
- Q3In Excel, if you want to count how many numbers are greater than or equal to 7, which function should you use?AVERAGEIFMAXCOUNTIFSUMIF30s
- Q4Which Excel function would you use to add up numbers that are less than 15?SUMIFCOUNTIFMEDIANAVERAGEIF30s
- Q5If you want to find the average of numbers that are above 20 in Excel, which function would you use?RANGEAVERAGEIFSUMIFCOUNTIF30s
- Q6Which function should you use in Excel to count how many scores are less than 50?COUNTIFAVERAGEIFMAXSUMIF30s
- Q7What Excel function can you use to add all numbers that are greater than 30?AVERAGEIFSUMIFMINCOUNTIF30s
- Q8If you're using Excel and want to find the average of values that are less than 25, which function would you use?COUNTIFPRODUCTAVERAGEIFSUMIF30s
- Q9To count how many numbers in a list are greater than 100 using Excel, which function should you choose?COUNTIFSUMIFAVERAGEIFMAX30s
- Q10What function would you use in Excel to sum numbers that are less than 5?AVERAGEIFCOUNTIFSUMIFMEDIAN30s