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:

Electronic Overload Unit

A protective device that monitors the current to motors and disconnects power in case of overload, preventing damage.

Overload Unit Contacts

Components within an overload relay that open or close electrical circuits to provide motor protection against excessive current.

Motor Starter Contactor

An electromechanical switch used to control the power supply to a motor, providing safe start and stop operations.

Motor Load Current

The current drawn by an electric motor under specific load conditions, indicative of the power it is using to perform its function.