Which Excel function takes as inputs two separate ranges, then multiplies each pair of numbers in the ranges, and then adds up all these individual products?
A) RANGE
B) RANGEPRODUCT
C) PRODUCTSUM
D) SUMPRODUCT
E) DOTPRODUCT

Question

Quizplus · Accepted Answer

The function that takes two separate ranges and multiplies each pair of numbers in the ranges and adds up all the individual products is SUMPRODUCT. Therefore, the correct choice is D.

Which Excel Function Takes as Inputs Two Separate Ranges, Then