Which of the following is equivalent to "=SUMPRODUCT(A1:A4,B2:B6) "?
A) A1*A4 + B2*B6
B) A1*B2 + A2*B3 + A3*B4 + A4*B5
C) (A1+A4) *(B2+B6)
D) (A1+A2+A3+A4) *(B2+B3+B4+B5+B6)
E) This is an invalid function.
Correct Answer:
Verified
Q71: Research has shown that most spreadsheet model
Q72: In Excel, what are the keystrokes for
Q73: In Excel, the command to print Cell
Q74: A common practice of scenario analysis is
Q75: What Excel feature works backwards to find
Q77: There are a number of different model
Q78: To edit formulas in Excel, you can
Q79: One reason for models is the need
Q80: In Excel, what are the keystrokes for
Q81: In Excel, the only way to center
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents