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

question 43

Multiple Choice

Which function 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:

Computerized Cash Register

An electronic device designed to handle sales transactions, equipped with the ability to store, process, and record sales data.

Supply Partnership

A strategic relationship between a supplier and a buyer aimed at improving efficiency, quality, and competitiveness.

Microprocessors

Integrated circuits that contain the basic functions of a central processing unit (CPU) of a computer, performing calculations and operations necessary to run software.

Supply Partnership

A strategic agreement between a buyer and a supplier aimed at increasing the value both parties receive from the relationship, often involving cooperation and long-term engagement.