Which Conditional Formatting Option Would You Choose If You Wanted

question 45

Multiple Choice

Which conditional formatting option would you choose if you wanted to apply formatting to cells whose value falls between two numbers?

• A)Top/Bottom Rules
• B)Highlight Cells Rules
• C)Between Values Rules
• D)Color Scales

---

Definitions:

Gross Income

The total income earned before any deductions or taxes are subtracted.

Back-end Ratio

A debt-to-income ratio that calculates the percentage of a person's gross income going toward paying all debt obligations, including mortgage and auto loans.

Expenses

Costs incurred or money spent on goods and services.

Escrow Account

An escrow account is a financial arrangement where funds or assets are held by a third party on behalf of two other parties in the process of completing a transaction.