Which of the following is not true about the IFS function?

A. It can evaluate up to 127 conditions.
B. It returns a result based on the first true condition.
C. It can return multiple true conditions.
D. The more conditions you use, the greater the tendency for errors in creating the formula.


Answer: C

Computer Science & Information Technology

You might also like to view...

A search for an item X in an array starts at the lower end of the array, and then looks for X by comparing array items to X in order of increasing subscript. Such a method is called

A) lower to upper search B) sequential search C) binary search D) selection search

Computer Science & Information Technology

Twitter is essentially a text-only service

Indicate whether the statement is true or false

Computer Science & Information Technology

The Between...And operator can be used to find all numbers or dates between and including two values

Indicate whether the statement is true or false

Computer Science & Information Technology

In File Explorer, the ________ is the toolbar located directly below the Ribbon

A) title bar B) Address bar C) status bar D) Navigation pane

Computer Science & Information Technology