Multiple Choice
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
Correct Answer:
Verified
Correct Answer:
Verified
Related Questions
Q78: The MATCH function returns the _ position
Q79: Which of the following is not one
Q80: What does it mean when the formula
Q81: In Excel, you can copy text labels
Q82: Define an output.
Q84: Which of the following models is "built"
Q85: A common practice of scenario analysis is
Q86: Describe the "IF" function in Excel.
Q87: Which of the following is not one
Q88: To add Cell Comments for a cell