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...

The policy allows people to pass tasks and responsibilities to other team members

What will be an ideal response?

Computer Science & Information Technology

An administrator is provisioning a 10GBaseSR Ethernet connection between two core switches. Which of the following cable types should the administrator plan to use?

A. Multimode fiber B. RG-6 copper C. Single-mode fiber D. CAT6 copper

Computer Science & Information Technology