Sumif
Presentation
•
Instructional Technology
•
9th - 12th Grade
•
Practice Problem
•
Medium
Andres Rengifo
Used 6+ times
FREE Resource
6 Slides • 5 Questions
1
2
Multiple Choice
What does the SUMIF function do?
The SUMIF function finds the maximum value in a range based on a condition.
The SUMIF function averages values based on a specified condition.
The SUMIF function sums values based on a specified condition.
The SUMIF function counts the number of cells that meet a condition.
3
Multiple Choice
_____ function is used to count the number of times a specified value as a criteria has been repeated within the specified range of cells.
COUNT BLANK
COUNTA
COUNT IF
COUNT
4
5
Multiple Choice
How would you write a formula to sum the values in cells B1 to B5?
=SUM(B1:B5)
=AVERAGE(B1:B5)
=COUNT(B1:B5)
=IF(B1:B5)
6
7
Multiple Choice
How would you use SUMIF to sum values greater than 10?
=SUMIF(range, ">5")
=SUMIF(range, "10")
=SUMIF(range, ">10")
=SUMIF(range, "<=10")
8
9
Multiple Choice
What is the purpose of the SUMIF function in Excel?
To sum all values in a range
To count the number of cells
To find the average of a range
To sum values based on a condition
10
11
Show answer
Auto Play
Slide 1 / 11
SLIDE
Similar Resources on Wayground
9 questions
Cultural Patterns 3.3
Presentation
•
9th - 12th Grade
8 questions
Introduction to Synthetic Substitution & Division of Polynomials
Presentation
•
9th - 12th Grade
10 questions
Calculating heat of phase changes
Presentation
•
9th - 12th Grade
9 questions
Gravity Model
Presentation
•
9th - 12th Grade
11 questions
The Ming Dynasty
Presentation
•
9th - 12th Grade
8 questions
Data Validation and Verification Review
Presentation
•
10th - 12th Grade
10 questions
Graphing Linear Systems
Presentation
•
9th - 12th Grade
12 questions
Asymptotes
Presentation
•
9th - 12th Grade
Popular Resources on Wayground
10 questions
HCS SCI 03 Summer School Review 4
Quiz
•
3rd Grade
11 questions
HSMS - Standard Response Protocol
Quiz
•
6th - 8th Grade
16 questions
1.1-1.2 Quiz Review
Quiz
•
9th - 12th Grade
12 questions
Exponent Expressions
Quiz
•
6th Grade
20 questions
Adding and Subtracting Integers
Quiz
•
6th - 7th Grade
11 questions
Northeast States
Quiz
•
3rd - 4th Grade
10 questions
Characterization
Quiz
•
3rd - 7th Grade
10 questions
Common Denominators
Quiz
•
5th Grade