If You Wanted Every Cell That Has a Value Over

question 67

Multiple Choice

If you wanted every cell that has a value over $1,251 to have a purple fill, you would use what feature in Excel?

• A)Conditional formatting
• B)AutoFill formatting
• C)AutoComplete formatting
• D)Aggregate Cell formatting

---

Definitions:

Conditional Sale Contract

A contract for the sale of goods where the payment of the price, or part of it, is deferred and the full ownership of the goods does not transfer until certain conditions, typically the full payment, are met.

Rate of Return

The gain or loss on an investment over a specified time period, expressed as a percentage of the investment's initial cost.

Compounded Semi-annually

A method of calculating interest where the interest is added to the principal twice a year, resulting in interest being earned on interest.

Compounded Semi-annually

Denotes the method of applying interest to a principal sum at mid-year and end of the year.