GoSkills
Back to lesson
Question
1
of
3
1. Which of the following is the correct syntax for the SUMIFS function?
=SUMIFS(Criterion_Range1, Criterion1, [Criterion_Range2, Criterion2, …],Sum_Range)
=SUMIFS(Sum_Range, Criterion_Range1, Criterion1, [Criterion_Range2, Criterion2, …])
=SUMIFS([Sum_Range], Criterion_Range1, Criterion1, [Criterion_Range2, Criterion2, …])
Don’t know
2. If no set of values satisfies the criteria in a SUMIFS formula (where the Sum_Range contains only numerical values), what will the result of the formula be?
#DIV/0!
Zero
#VALUE!
Don’t know
3. In the SUMIFS function, if criterion ranges are not of equal dimensions (i.e. same number of rows / columns), what error message would Excel display?
#REF!
#VALUE!
#N/A
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement