Which Formula Should Be Used to Determine the Net Flow

question 64

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)SUMPRODUCTB6:B16,G6:G16)

---

Definitions:

Corporate Accountability

The responsibility of companies to be answerable for their actions, ensuring ethical conduct, compliance with regulations, and positive impact on society.

Sustainable Tourism

The practice of recreational traveling in a way that maximizes the social and economic benefits to the local community and minimizes the negative impact on cultural heritage and the environment.

Cultural Heritage

Refers to the legacy of physical artifacts and intangible attributes of a group or society that are inherited from past generations, preserved in the present, and bestowed for the benefit of future generations.

Recreational Traveling

Travelling undertaken for pleasure and enjoyment, as opposed to business or practical reasons, often involving exploring new places and experiences.