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:

Capital Asset

Any type of asset that is held for investment or for personal use, including stocks, bonds, real estate properties, and collectibles, among others.

Taxpayer

An individual or entity legally obligated to pay taxes to a governmental authority, such as the IRS.

Section 1231

A tax provision that allows for the favorable tax treatment of gains on the sale or exchange of certain types of property used in a business.

Trade or Business

An activity carried out for the purpose of earning income or profit, involving regularity and continuity in operations.