Which of the Following Is Equivalent to "=SUMPRODUCT(A1:A4,B2:B6)

question 100

Multiple Choice

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.

---

Definitions:

Accounting Process

The systematic series of steps taken to record financial transactions and prepare financial statements in accordance with accounting standards.

Working Knowledge

A practical understanding or awareness of a subject or skill, sufficient to perform tasks or make decisions related to it.

Accounting Relevance

The importance of financial information in making informed business decisions due to its material impact on evaluating past, present, or future events.

Accounting Information

The data produced through the accounting process, which is used for decision-making, financial analysis, and reporting.