IF(), OR(), AND(), TExt(), LEFT(), RIGHT()

Which function do we use in this picture?

• =IF()

• =AND()

• =OR()

• =Text()

Which function do we use in this picture?

• =IF()

• =AND()

• =OR()

• =Text()

Which function do we use in this picture?

• =IF()

• =AND()

• =OR()

• =Text()

Which function do we use to convert the letter in the cell?

• =IF()

• =AND()

• =OR()

• =Text()

True/False: LEFT(text,num_chars)

• True

• False

Chan Dara =Left(A1,3) will show____

• Cha

• Chan

• Dar

• Dara

Chan Dara =Right(A1,3) will show____

• Cha

• Chan

• ara

• Dara

Chan Dara =Mid(A1,5,3) will show____

• Cha

• Chan

• Dar

• Dara

True/False =TEXT(A1,dd-mmm-yy)

• True

• False

to determine if any conditions in a test are TRUE.

• OR

• And