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
Beginner
In the illustration, which formula typed into cell C17 would derive the same result as that already calculated in cell D15?
=SUMPRODUCT(B5:B14,C5:C14)
=SUMPRODUCT(B5:C14)
=SUMPRODUCT(B5:B14+C5:C14)
Don’t know
2
Beginner
In this example, the formula =SUMPRODUCT((B5:B16=J4)*(C5:C16=J5)*(D5:D16=J6)*(E5:E16=J7)*F5:F16) has been used to show an alternative to using the SUMIFS function. Which of the following is the primary reason the various arguments multiplied (e.g. (B5:B16=J4)) are delineated using brackets?
It makes the formula easier to read
This is because otherwise multiplication will be performed by Excel before the equality checks (i.e. it is to ensure the correct calculation order)
The SUMPRODUCT syntax requires all ranges to be included in brackets.
Don’t know
3
Beginner
Which of the following statements is true concerning the SUMPRODUCT function?
The SUMPRODUCT function will not work with entries that are not numeric
SUMPRODUCT works with array arguments of different dimensions
SUMPRODUCT enables the user to avoid using complicated formulae by summing up the products of individual corresponding cells referenced vectors or arrays with shared dimensions.
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement