Question: an infield fly. table [ [ Task # , Points,Task Description ] , [ 1 , 9 , table [ [ Use the

an infield fly.
\table[[Task #,Points,Task Description],[1,9,\table[[Use the AND function with appropriate arguments in cell H11 to determine if there is a force out at third base. There is a force out at third base if],["Runner on 1st" and "Runner on 2nd" are both "Yes".]]],[2,1,Copy your function in cell H11 and paste it down to complete the "Force @ Third" column of the table.],[3,7,\table[[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").]]],[4,1,Copy your function in cell I11 and paste it down to complete the "Fly Ball" column of the table.],[5,7,Use the NOT function in cell J11 to determine if there are "Not 2 Outs". Use the "Outs" column in your determination.],[6,1,Copy your function in cell J11 and paste it down to complete the "Not 2 Outs" column of the table.],[7,3,\table[[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 hit to the infield or shallow outfield (I11= TRUE), and there must not be 2 outs (J11=],[TRUE).]]],[8,1,Copy your function in cell K11 and paste it down to complete the "Infield Fly" column of the table.],[Total:,30,]]
 an infield fly. \table[[Task #,Points,Task Description],[1,9,\table[[Use the AND function with appropriate

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!