Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Advanced
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)?
There is no difference
The comma notation sums elements of ranges, whereas the multiplication notation multiplies these same elements
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
Advanced
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 except errors
All non-numerical values are treated as zeros
Don’t know
3
Advanced
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
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement