An Icon Set

question 63

Multiple Choice

An icon set

• A) is a conditional format that displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range.
• B) highlights cells meeting specified criteria with a specified color, font, or border.
• C) calculates an aggregate for values in a range or database.
• D) is a conditional format that displays a particular color based on the relative value of the cell contents to other selected cells.

---

Definitions:

Gross Profit

The profit a company makes after deducting the costs associated with making and selling its products, or the costs associated with providing its services.

Net Sales

The total revenue generated from goods or services sold, after deducting returns, allowances for damaged or missing goods, and discounts.

Cost of Goods Sold

Direct costs attributable to the production of the goods sold by a company, including materials and labor costs.

Merchandise Inventory

Goods that a retail or wholesale company intends to sell to customers. The inventory account is adjusted based on purchases and sales.