What Does the Excel "=SUMPRODUCT(A1:A5,C6;C10)" Function Do

question 12

Multiple Choice

What does the Excel "=SUMPRODUCT(A1:A5,C6;C10) " function do?

• A) Sums each range and multiplies the sums.
• B) Sum each pair of cells and multiples each sum.
• C) Multiplies the contents of cells containing the =SUM() command.
• D) Multiplies each pair of cells in two arrays matched by position and sums the products.

---

Definitions:

Repossess

The act of taking back property by a seller or lender from the buyer or borrower, usually due to failure in payment.

Security Registered

Refers to financial securities that are registered with regulatory bodies and recorded in the named investor's name.

Fraudulent Conveyances Act

A law aimed at preventing the illegal transfer of property by a debtor to avoid it being claimed by creditors.

Province

A territorial unit within a country or country-like entity, often with its own government and administrative responsibilities.