All of the Following Statements Are TRUE About Nested IF

question 89

Multiple Choice

All of the following statements are TRUE about nested IF functions EXCEPT:

• A)Each nested function needs a pair of parentheses.
• B)Excel color codes parentheses to indicate which parentheses are paired.
• C)Nested IF functions permit more than two outcomes.
• D)The outcome of a nested IF function is limited to numeric or text values.

---

Definitions:

Acceptance Sampling

A statistical quality control method used to determine whether to accept or reject a batch of products based on a sample of items from the batch.

Process Capability Index

A statistical measure of a process's ability to produce output within specified limits.

C-Chart

A quality control chart used to control the number of defects per unit of output.