If Cell G7 Contains the Function , It States That

Multiple Choice

If cell G7 contains the function , it states that if the value in cell C3 is 9, the number 7 will be assigned to cell G7; if the value in cell C3 is not 9, the number 4 will be assigned to cell G7.

A) =IF(G7=9) (G7=7) =OR(G7=4)
B) =IF(G7=7) =THEN(C3=9) =OR(C3=4)
C) =IF(C3=9) (C3=7) =OR(C3=4)
D) =IF(C3=9,7,4)