Need the functions for these questions please!

Alignment Number X fe SANDI B D E G H Scenario Catchable Fly Ball Hit to... Infield Shallow Outfield 1 Yes Force at Third Fly Ball Not 2 Outs Infield Fly HANDO AND(logical1, [logical21... 2 NO Outs 0 0 0 NO Yes No NO No 3 4 5 Yes 2 0 1 6 our NO 7 1 No NO NO Yes No No Yes No Yes No Yes No No Yes NO Runner Runner on 1st on 2nd Yes No Yes Yes No NO Yes Yes No No Yes Yes Yes Yes Yes Yes Yes No No Yes Yes NO Yes No Yes Yes Yes No No NO Yes No No NO No Yes Yes Yes Yes No 2 1 1 Yes ONO 2 NO 2 No 1 0 No NO 8 9 20 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 0 No No Yes NO No Yes Yes Yes Yes NO No Yes Yes Yes No No Yes No No No NO NO No Yes No OOOOOO No Yes 1 1 No No No Yes Yes No NO Yes No No Yes No NO Yes Yes No Yes Yes Yes Yes NNWOOD NO 2 2 NO NO If Function Lookup Functions Conditional Functions Boolean Functions (1.1) Use the AND function with appropriate arguments in cell ( H4) to determine if there is a force out at third base. a. There is a force out at third base if "Runner on 1st" and "Runner on 2nd" are both "Yes". 1.3 ) Use the OR function with appropriate arguments in cell (14) to determine if there is a "Fly Ball". a. There is a "Fly Ball" if a "Catchable Fly Ball is Hit to" the "Infield" (cell (E4) is "Yes" or "Shallow Outfield" (cell (F4) is "Yes"). 1.5 ) Use the NOT function in cell (4) to determine if there are "Not 2 Outs". Use the "Outs" column in your determination