We will us an AVERAGEIF function, which averages selected values that satisfy a specified condition. In the yellow cell immediately below write an AVERAGEIF Function which averages the values in the range F136:1136. for which the respective value in F135:H135 is 'Yes'. Yes No No Yes 5 7 9 11 In the yellow cell immediately below write an AND Function embedded in an IF function that sets the cell equal to 1 if G96=H96=196=1 and 0 otherwise. 1 2 3 If cell B96 turns red, fix the expression in B96. Hint: this requires combining multiple conditions using a logical function. We will us an AVERAGEIF function, which averages selected values that satisfy a specified condition. In the yellow cell immediately below write an AVERAGEIF Function which averages the values in the range F136:1136. for which the respective value in F135:H135 is 'Yes'. Yes No No Yes 5 7 9 11 In the yellow cell immediately below write an AND Function embedded in an IF function that sets the cell equal to 1 if G96=H96=196=1 and 0 otherwise. 1 2 3 If cell B96 turns red, fix the expression in B96. Hint: this requires combining multiple conditions using a logical function