Which Formula Should Be Used to Determine the Net Flow

question 49

Multiple Choice

Which formula should be used to determine the Net Flow values in cell K6 in the following spreadsheet model?

• A) SUMIF($C$6:$C$16,I6,$B$6:$B$16)−SUMIF($E$6:$E$16,I6,$B$6:$B$16)
• B) SUMIF($I$6:$I$12,B6,$B$6:$B$16)−SUMIF($I$6:$I$12,I6,$B$6:$B$16)
• C) SUMIF($E$6:$E$16,I6,$B$6:$B$16)−SUMIF($C$6:$C$16,I6,$B$6:$B$16)
• D) SUMPRODUCT(B6:B16,G6:G16)

---

Definitions:

Major Depressive Disorder

A serious to severe depressive disorder in which the person may show loss of appetite, psychomotor retardation, and impaired reality testing.

Delusional Disorder

A psychiatric condition characterized by persistent delusions, which are false beliefs that conflict with reality, in the absence of other major psychiatric symptoms.

Conversion Disorder

Conversion disorder is a mental condition in which a person experiences neurological symptoms, such as paralysis or blindness, without a physical cause.

Illness Anxiety Disorder

A chronic condition characterized by excessive concern and anxiety about having a serious illness, despite medical reassurance.