When the Data Are Large and When It Is Difficult

question 18

Multiple Choice

When the data are large and when it is difficult to analyze all at once, which of the following feature in Excel is used to make the data more manageable and to develop insights?

• A) Frequency table
• B) Sorting and filtering
• C) Fill color
• D) Charts

Calculate cash flows from operating activities using the indirect method.

Recognize the treatment of losses and gains from the sale of assets in the statement of cash flows.

Understand the indirect and direct methods for preparing the statement of cash flows.

Identify and categorize cash flow activities into operating, investing, and financing activities.

---

Definitions:

Compounded Annually

Refers to the process of calculating interest on both the initial principal and the accumulated interest from previous periods on an annual basis.

Lump Sum Payment

A single payment made at a particular time, as opposed to several smaller payments or installments.

Compounded Annually

A method of calculating interest where the interest earned over a period is added to the principal, and the total becomes the base for the calculation of the next period's interest.

Lump Sum Payment

A payment made in a single lump sum amount, often used in the context of paying off debts or settling transactions.