<span>He would click on the Test 1 column and press Sort, then click on the Test 2 column and press Sort.
It depends on what you learn because it says "shift"</span>
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.
