Question

1-Use the OR function with appropriate arguments in cell I11 to determine if there is a "Fly Ball". There is a "Fly Ball" if a "Catchable Fly Ball [is] Hit to" the "Infield" (cell E11 is "Yes") or "Shallow Outfield" (cell F11 is "Yes").

2-Use the NOT function in cell J11 to determine if there are "Not 2 Outs". Use the "Outs" column in your determination.

3-Use the AND function in cell K11 to determine if all of the conditions are met for an infield fly to be declared. These conditions are: there must be a force out at third (H11 = TRUE), there must be a catchable fly ball it to the infield or shallow outfield (I11 = TRUE), and there must not be 2 outs (J11 = TRUE).

Please, I need help finishing this excel assignment.

Assignment Tasks Boolean Home Insert Design La Use the OR function with appropriate arguments in cell 111 to determine if there is a "Fly mments Ball". There is a "Fly Ball" if a "Catchable Fly Ball [is] Hit to" the "Infield" (cell E11 is "Yes") or "Shallow Outfield" (cell F11 is "Yes"). 7 points] 3 Viber Screen Shot AutoSave OFF logicandreference-a9-nesrine_haddar Q Search Sheet Home Insert Draw Page Layout Formulas Dta Review View Assignment Share -Comments Instruction Task Submit View Sheet Guide Report An infield fly in baseball is called to prevent the defense from recording an easy double play. When an infield fly occurs, the batter is automatically out once the ball is touched by a fielder or hits the ground and the baserunners must go back to their bases (though they may "tag up" if they wish). An infield fly occurs when the following conditions are met: (1)thereis a force out at third base (this means that there are runners on first base and second base), (2) there arenot two outs, and (3) the batter hits a catchable fly ball to the infleld or the shallow outfield. The table below highlights 30 baseball scenarios. Complete the tasks below to determine if the umpire should declare an infield f OR Catchable Fly Ball Hit to... Infield Scenario Runner on 1st Yes Yes Runner on 2nd Shallow Outfield Outs ForceThird Fly BallNot 2 Outs Infield Fly FALSE OR FALSE FALSE FALSE TRUE FALSE TRUE TRUE TRUE TRUE FALSE TRUE FALSE FALSE TRUE FALSE FALSE FALSE FALSE TRUE TRUE FALSE No es No No Yes No No No No Yes Yes Yes Yes No No No Yes Yes No Yes Yes No Yes Yes Yes No No No No No Yes 20 Yes Yes No Boolean Functions IF Function Lookup Functions Conditional Functions

Answer 1

"First download the excel sheet and complete the column Force@Third (Coulmn H) by using the formula: AND(C11 = ""Yes"", D11 = ""Yes"") Then, drag down to complete entire column. 1) The OR function to determine if there is a ""Fly Ball"" (Column I) is as follows: = OR (E11 = ""Yes"", F11 = ""Yes"") Apply the above formula and drag it down to complete the column I The screenshot after the formula is as follows: 2) The NOT function to determine if there are ""Not 2 Outs"" is as follows: = NOT (G11 < > 2) The Screenshot after applying the formula is as follows 3) The AND function to determine if all conditions are met for an infield fly to be declared is as follows: = AND (H11 = TRUE, I11 = TRUE, J11 = TRUE) The screenshot is as follows: The final excel sheet after applying all the formulas is as follows: "

The final excel sheet after applying all the formulas is as follows: