The ______________ function allows users to display data if a condition is true or false.

The ______________ function allows users to display data if a condition is true or false.

• A. If
• B. Then
• C. While
• D. When

Answer: (A)

Displaying data based on a condition is handled by the IF function. It checks a condition and returns one result when true and another when false, typically written as IF(condition, value_if_true, value_if_false). This setup lets you show data only if the condition is met, or display an alternative otherwise. The other options don’t serve this two-way conditional purpose: one isn’t a standalone conditional function, one is a looping construct that runs while a condition remains true, and the last isn’t a standard conditional operator in this context. So the first option best matches the function designed for this kind of true/false display.

Displaying data based on a condition is handled by the IF function. It checks a condition and returns one result when true and another when false, typically written as IF(condition, value_if_true, value_if_false). This setup lets you show data only if the condition is met, or display an alternative otherwise. The other options don’t serve this two-way conditional purpose: one isn’t a standalone conditional function, one is a looping construct that runs while a condition remains true, and the last isn’t a standard conditional operator in this context. So the first option best matches the function designed for this kind of true/false display.