Question

Select the correct answer from each drop-down menu. Which IF formulas are valid? _____ and _____ are valid IF formulas.

FIRST BLANK

=IF(D3>50; E3; F3)
=IF(D3>50);( E3; F3)
=IF(10<5;23);("Incorrect")

SECOND BLANK

=IF(A1>60;"Pass";"Fail")
=IF(A1>60); ("Pass"; "Fail")
=IF(A1>60; ("Pass"; "Fail"))

Answer 1

1. =IF(D3>50; E3; F3)

2. =IF(A1>60;“Pass”;“Fail”)

Step-by-step explanation:

i did the test

Answer 2

=IF(D3>50; E3; F3) AND =IF(A1>60;"Pass";"Fail")

Step-by-step explanation:

An IF structure is built following this pattern:

IF(TEST;IFTRUE;IFFALSE)

These are the only options in the given drop-down menus what comply with this pattern. All others are not following this pattern.

The computer will do the test and if the result is true will apply the IFTRUE value, otherwise will apply the IFFALSE value.