Which Formula Should Be Used to Determine the Net Flow

question 8

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:

Entitlements

Programs for which funding is mandatory and guaranteed by law to those who meet eligibility criteria, such as Social Security and Medicare.

Eligible Person

An individual who meets specific criteria or requirements, making them qualified to receive certain benefits, rights, or services.

Pay-As-You-Go System

A financial policy where expenses must be funded out of current revenues without resorting to borrowing or debt.

Social Security

A government program that provides financial assistance to people with an inadequate or no income, primarily the elderly and disabled.