H logicandreference-a9-Elizabeth_Farr (5) - Excel Home Insert Page Layout Formulas Data Review View Help Assignment ?

Please provide the formulas for the missing columns.

• Attachment 1
• Attachment 2
• Attachment 3
• Attachment 4

Hlogicandreference-a9-Elizabeth_Farr (5) - ExcelHomeInsertPage LayoutFormulasDataReviewViewHelpAssignment? Tell me what you want to dotuctionTaskSubmit ViewsheetGuideReportow Instructions Automatic ScoringXDAn infield fly in baseball is called to prevent the defense from recording an easy double play. When an infield fly occurs, the batter isautomatically out once the ball is touched by a fielder or hits the ground and the baserunners must go back to their bases (though theymay "tag up" if they wish). An infield fly occurs when the following conditions are met: (1) there is a force out at third base (this meansthat there are runners on first base and second base), (2) there are not two outs, and (3) the batter hits a catchable fly ball to the infield orthe shallow outfield. The table below highlights 30 baseball scenarios. Complete the tasks below to determine if the umpire shoulddeclare an infield fly.Catchable Fly Ball Hit to...Scenario Runner on 1st Runner on 2ndInfieldShallow Outfield Outs Force @ ThirdFly BallNot 2 Outs Infield FlyYesNoNoYes0YesNoYesNomYesNoNoYesNoYesNoNo2YesYesNoNoNoNoNoYes1YesYesNoNoYesYesNoYesYesYesNoNoYesNoYesNoYesNoNoNoYesYesYesNoHNHHONONHoooNoYesNoYesNoYesNoNoYesYesYesNoNoNoYesNoNoYesYesNoYesONNoNoNoNoNoNoBoolean FunctionsIF FunctionLookup FunctionsConditional FunctionsReadyO Type here to searcheXMacBook Airesc. ' .F1F220F3000F4F5F6F7F8@LA#%A&*2569