Which Excel Function Takes as Inputs Two Separate Ranges, Then

question 83

Multiple Choice

Which Excel function takes as inputs two separate ranges, then multiplies each pair of numbers in the ranges, and then adds up all these individual products?

• A) RANGE
• B) RANGEPRODUCT
• C) PRODUCTSUM
• D) SUMPRODUCT
• E) DOTPRODUCT

---

Definitions:

Corporate Powers

The legal capacities and rights granted to a corporation by law, allowing it to act as a legal entity for conducting business, entering into contracts, and owning property.

Bonded Debt

Long-term debt secured by a guarantee (bond) that obligates the issuer to repay the borrowed amount at specified terms, commonly used by corporations and governments.

CAFR

Comprehensive Annual Financial Report, a set of government financial statements that provides a complete overview of a government entity's financial status.

Management's Discussion and Analysis

A section of a company's financial report that provides an overview of the previous fiscal period's operations, financial condition, and future prospects.