nellyjsotelo
contestada

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"))

Respuesta :

sylvain96

Answer:

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

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.

Answer:

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

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

Explanation:

i did the test

Otras preguntas