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

question 115

Multiple Choice

Which of the following is equivalent to "=SUMPRODUCT(A1:A4,B1:B4) "?

• A) A1*A4 + B1*B4
• B) A1*B1 + A2*B2 + A3*B3 + A4*B4
• C) (A1+A4)*(B1+B4)
• D) (A1+A2+A3+A4)*(B1+B2+B3+B4)
• E) A1 + A4*B1 + B4

---

Definitions:

Programmed Decisions

Decisions that are routine and repetitive, made within the framework of company policies and procedures.

Reality Checks

Methods or situations that force an individual or group to consider the actual circumstances surrounding them, often dispelling illusions.

Semiprogrammed Decisions

Decisions that are made with a mix of established procedures and the judgment of the decision-maker, often used when faced with partially known circumstances.

Contingent Decisions

Contingent decisions are decisions made based on certain conditions or situations arising, meaning they are dependent on particular events or circumstances.