In order to create a chart, which of the following must be selected?
O Data tools
The USE statement switches to a different database.
Answer:
=IF(D3>50; E3; F3) and =IF(A1>60;"Pass";"Fail") are valid IF formulas.
Explanation:
P.S - The exact question is -
To find - 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"))
Solution -
An IF structure is built following this pattern:
IF(TEST;IF TRUE;IF FALSE)
So,
The correct option is -
=IF(D3>50; E3; F3) and =IF(A1>60;"Pass";"Fail") are valid IF formulas.
