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:

Manufacturing Productivity

measures the efficiency of the production process, typically quantified as the ratio of outputs produced to inputs used in the manufacturing process.

Internal Rate of Return

This is a financial metric used to estimate the profitability of potential investments, calculated as the rate of return that makes the net present value of all cash flows from a particular project equal to zero.

Net Cash Flows

The difference between a company's cash inflows and outflows over a specified period.

Average Investment

A metric used to evaluate the efficiency of an investment or to compare the efficiency of a number of different investments.