The __________ function pairs each element of the first array with its counterpart in the second array, multiplies the elements of the pairs together, and adds the results.
A)SUM
B)SUMPRODUCT
C)SUMIF
D)VLOOKUP

Question

Quizplus · Accepted Answer

The SUMPRODUCT function is designed to multiply corresponding elements in arrays and then sum the products. This is the required process mentioned in the given question.

The __________ Function Pairs Each Element of the First Array