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