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

question 55

Multiple Choice

What does the Excel =SUMPRODUCT(A1:A5,C6;C10) command 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 and sums each product.

---

Definitions:

Materials Requirement Planning

A production planning, scheduling, and inventory control system used to manage manufacturing processes.

Just-In-Time Inventory

An inventory management strategy that aligns raw-material orders with production schedules to minimize inventory costs and reduce waste.

Vendor-Managed Inventory

A supply chain management strategy where the supplier is responsible for maintaining the inventory levels at the buyer's premises.

Vendor-Managed Inventory

A supply chain initiative where the supplier assumes the responsibility of managing inventory levels for the customer.