Which of the Following Types of Conditional Formatting Rules Identifies

question 65

Multiple Choice

Which of the following types of conditional formatting rules identifies a set of the highest or lowest values in a field or column?

• A) Icon Sets
• B) Color Scales
• C) Top/Bottom Rules
• D) Highlight Cells Rules

---

Definitions:

Form 1040

This is the standard IRS form individuals use to file their annual income tax returns.

Lifetime Learning Credit

A tax credit that provides financial assistance for post-secondary education by allowing taxpayers to deduct a percentage of their tuition and fees.

Modified AGI

Adjusted Gross Income (AGI) with certain adjustments added back in, often used in tax calculations to determine eligibility for certain tax benefits.

Married Filing Joint

A filing status on U.S. tax returns allowing married couples to combine their incomes, deductions, and credits on a single tax return, potentially leading to tax benefits.