Question

function arguments
if
logical_test: a2 <= 55 = true
value_if_true:
o fine\ =
o fine\
value_if_false: 20*(a2-55) = -1100
=
o fine\
checks whether a condition is met, and returns one value if true, and another value if false.
value_if_false is the value that is returned if logical_test is false. if omitted, false is returned.
formula result = no fine

0

o fine\
200
110

Explanation:

Analyze the Function Arguments dialog box

The image shows an Excel "Function Arguments" dialog box for the IF function.
The arguments are:

• Logical_test: A2 <= 55 (which evaluates to TRUE)
• Value_if_true: "No Fine"
• Value_if_false: 20*(A2-55)

Determine the formula result

Since the Logical_test evaluates to TRUE, the function returns the Value_if_true argument.
The value of Value_if_true is "No Fine".
This is also explicitly shown in the dialog box next to "Formula result = No Fine".

Match with the multiple-choice options

The options provided are:

• 0
• "No Fine"
• 200
• 110

The correct option is "No Fine".

Answer:

• 0
• "No Fine" (Correct answer)
• 200
• 110