GoSkills
Back to lesson
Question
1
of
3
1. What is the main difference between the comma notation form of SUMPRODUCT (=SUMPRODUCT(Argument1, Argument2) and the multiplication notation form of SUMPRODUCT (=SUMPRODUCT(Argument1 * Argument2)?
The comma notation sums elements of ranges, whereas the multiplication notation multiplies these same elements
There is no difference
The comma notation only allows cross-multiplication between ranges containing only one row or only one column, whereas the multiplication form allows a form of matrix algebra
Don’t know
2. How does SUMPRODUCT treat non-numerical entries?
Since text multiplied by a number gives #VALUE!, SUMPRODUCT gives this same error
All non-numerical values are treated as zeros
All non-numerical values are treated as zeros except errors
Don’t know
3. Which of the following formulae would calculate the weighted average of the data correctly?
=SUMPRODUCT(A2:A6/B2:B6)
=SUMPRODUCT(A2:A6,B2:B6)/SUM(A2:A6)
=SUMPRODUCT(A2:A6,B2:B6)/SUM(B2:B6)
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement