IF, OR, AND, Left, Right, and Left

Choose the correct answer below: A2>=30

• A2ធំជាងឬស្មើរ30

• A2តូចជាងឬស្មើរ30

• A2ធំជាង30

• A2តូចជាង30

True/False: =IF(A2>=30,"B",IF(A2>=25,"C",""))

• True

• False

Choose 3 incorrect answers below: =OR () Function

• =IF(OR(A3=18,B3="Female"),100,"")

• =IF(OR(A3=18),(B3="Female"),100,"")

• =IF(OR(A3=18,B3="Female")100,"")

• =IF(OR(A3=18,B3="Female")100)

Choose 3 correct answers below: =AND ()

• =IF(AND(B3="Male", C3=20),100,0)

• =IF(AND(B3="Male", C3=20),100,"")

• =IF(AND(B3="Male", C3=20),100)

• =IF(AND(B3=Male, C3=20),100,0)

TRUE/FALSE: =AND(1=1,2=2,3=3)

• TRUE

• FALSE

TRUE/FALSE: =AND(1=2,2=3,3=4)

• TURE

• FALSE

TRUE/FALSE: =OR(1=2,2=3)

• TRUE

• FALSE

=Left () function extracts the number of characters from the ______

• Left side

• Right side

• Mide side

• Text

=Right () function extracts the number of characters from the ______

• Left side

• Right side

• Mide side

• Text

=MID () function extracts a given number of characters from ____

• Left side

• Right side

• the middle

• Text