If the Conditions Are Not Mutually Exclusive, Resulting in More

question 34

Multiple Choice

If the conditions are not mutually exclusive, resulting in more than one specified condition being TRUE, the formatting ____.

• A) of the last specified rule overrides those of earlier rules
• B) of the first specified rule overrides those of later rules
• C) defaults back to match the rest of the spreadsheet
• D) is applied by merging the formatting of all of the conditions

---

Definitions:

Efficiency

The ability to produce maximum output with a given set of inputs or resources, minimizing waste and costs.

Equality

The state of being equal, especially in status, rights, and opportunities.

Output

The complete sum of products or services generated by an individual, device, company, or economic system.

Total Surplus

The aggregate benefit to society, represented by the consumer and producer surplus, from the consumption and production of a good or service.