When Working with Data Sets in Excel, __________ Can Be

question 19

Multiple Choice

When working with data sets in Excel, __________ can be used to automatically highlight cells that meet specified requirements.

• A)averaging
• B)conditional formatting
• C)summing
• D)sorting

---

Definitions:

Cash Flow Statement

A cash flow statement is a financial document that provides aggregate data regarding all cash inflows a company receives from its ongoing operations and external investment sources, as well as all cash outflows that pay for business activities and investments during a given period.

Non-cash Expenses

Expenses recorded on a company's income statement that do not involve an actual cash outlay, such as depreciation or amortization.

Sales Returns and Allowances

Deductions from gross sales that reflect products returned by customers and discounts provided for minor defects.

Contra-asset Account

A type of account in the general ledger that reduces the value of a related account when its balance is subtracted from the balance of the related account.