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.


Answer: D

Computer Science & Information Technology

You might also like to view...

A ____________ linked list has nodes that contain two references to Nodes.

(a) circular (b) sequential (c) doubly (d) one-way

Computer Science & Information Technology

What's the difference between recordable and rewritable versions of the CD, DVD and Blu-ray optical storage devices?

What will be an ideal response?

Computer Science & Information Technology

List three reasons people might be reluctant to use biometrics for authentication. Can you think of ways to counter those objections?

What will be an ideal response?

Computer Science & Information Technology

In Unix, the ____ determines the file permissions.

A. file location B. file contents C. file owner D. inode number

Computer Science & Information Technology