GoSkills
Back to lesson
Question
1
of
3
1. Which of the following is true about the SUMIF function?
The function is case sensitive
If there are no exact matches to the condition, SUMIF will take the best approximation
A dynamic condition requires concatenation (e.g. the use of ‘&’)
Don’t know
2. The syntax of SUMIF is SUMIF(Range,Criterion,Sum_Range). Which argument is not necessarily required?
Range (if not specified, Sum_Range is used instead)
Criterion
Sum_Range (if not specified, Range is used instead)
Don’t know
3. In this example, Business Units A, B, C and D make sales as recorded. What should the amount be displayed in cell G5 if the formula is =SUMIF(B5:B16,B12,C5:C16)?
The sum of all B’s sales, i.e. $1,800
The sum of all A’s sales, i.e. $1,000
The sum of all C’s sales, i.e. $2,700
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement