Which Command Is Equivalent to =SUMPRODUCT(A1:A3,B1:B3)

question 79

Multiple Choice

Which command is equivalent to =SUMPRODUCT(A1:A3,B1:B3) ?

• A)=SUM(PRODUCT((A1:A3,B1:B3))
• B)=PRODUCT(SUM((A1:A3,B1:B3))
• C)=PRODUCT(A1+B1,A2+B2,A3+B3))
• D)=A1*B1+A2*B2+A3*B3

---

Definitions:

Diethyl Ether

An organic compound commonly used as a solvent, characterized by an oxygen atom connecting two ethyl groups.

1-Butanol

A primary alcohol with the chemical formula C4H9OH, characterized by a four-carbon straight chain terminating in a hydroxyl group.

PhCHO

Formaldehyde with a phenyl group, also known as benzaldehyde, a common organic compound used in synthesis.

Reagents

Substances or compounds added to a system to cause a chemical reaction.