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.
"A computerized spreadsheet automatically recalculates when changes are made to the data" is the one among the following that <span>is true about a computerized spreadsheet. The correct option among all the options that are given in the question is the third option or option "C". I hope it helps you.</span>