Font size
WorksheetsIF, OR, AND, Left, Right, and Left
Total questions: 10
Worksheet time: 6mins
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
