Question

question 3
which statement best describes what if() does (as a logic structure)?

• it converts a number into text
• it chooses between two outcomes based on whether a condition is true or false
• it sorts values into ascending order
• it repeats steps until a condition becomes true

Explanation:

• The first option is incorrect because converting a number to text is done by functions like TEXT() in spreadsheets, not IF().
• The second option is correct. The IF() function in logic structures (e.g., in programming or spreadsheets) evaluates a condition; if the condition is TRUE, it returns one outcome, and if FALSE, it returns another outcome.
• The third option is incorrect as sorting values into ascending order is done by sorting functions (like SORT() in some tools), not IF().
• The fourth option is incorrect as repeating steps until a condition is true is the behavior of a loop (like a while loop), not the IF() function.

Answer:

B. It chooses between two outcomes based on whether a condition is TRUE or FALSE