WEEK 6 DAY 3 TLE/EPP6 (ICT).PPPPPPPPPPPPP

INFORMATION COMMUNICATIONS TECHNOLOGY (ICT

1. SELECTED TEXT AND LOGICAL FUNCTIONS IN MICROSOFT EXCEL

2. Let us explore this time some of the text and logical functions in Microsoft Excel.

3. FUNCTION DESCRIPTION SYNTAX CON CATENATE Joins several text strings into one text strings CONCATENATE(text1, text2,…) LEN Returns the number of characters in a text string LEN(text) LOWER Converts all letters in a text LOWER(text) UPPER Converts all letters in a text string to upper UPPER(text)

4. LEFT Returns the leftmost characters from a text value LEFT( text,num_chars ) RIGHT Returns the rightmost characters from a text value RIGHT( text,num_chars ) AND Returns TRUE if all its argument are TRUE AND(logical 1, logical2,…) IF Checks whether a condition is met and returns one value if TRUE , otherwise IF( logical_test,value_if_true,value_if_false ) OR Returns TRUE if any arguments is true OR(logical1,logical2,..)

5. Go to cell D2 and try the following: Now , lets try the selected functions by first copying the given sample data below in your own worksheet :

6. If you want to create a sentence by joining the data in the cells with other text, then type the formula below and you will get “The teacher of Xavier is A” for the first cell. =CONCATENATE(“the teacher of “,A2”is”,B2) CONCATENATE Function

7. If you want to find the number of characters in a cell, then type the given formula and you will get 6 =LEN(A2) LEN Function

8. If you want to change the text to all lowercase, then type the formula below and you will get “ xavier ” =LOWER(A2) LOWER Function

9. If you want to change the text to all uppercase, then type the formula below and you will get “XAVIER” =UPPER(A2) UPPER Function

10. If you want get the first character of the string in the cell, then type the formula below and you will get “X” =LEFT(A2) If you want to get the first two character of the string of a cell , then type the formula below and you will get “ Xa ” =LEFT(A2,2) LEFT Function

11. If you want get the first character of the right of the string in a cell, then type the formula below and you will get “r’. =RIGHT(A2) If you want to get the first two character to the right of the string of a cell , then type the formula below and you will get “ er ” =RIGHT(A2,2) RIGHT Function

12. If you want to return one value if a condition is true and another value if it’s false , then try the following: =IF(C2>35,”Very Good”, Good”) R esults: Very Good IF Function

13. If you want to evaluate whether the arguments are true, then type the following: =AND(2+2=4,2+3=5) R esults: TRUE =AND(1<C2,C2<100) Results: TRUE IF(AND(1<C2,C2<100),A2 “The value is out of range.”) Results: Xavier AND Function

14. If you want to evaluate if any of the argument is true, then type the following: =OR(2+2=4,2+3=5) R esults: TRUE =OR(50<C2,C2<100) Results: TRUE IF(OR(50<C2,C2>100),A2 “The value is out of range.”) Results: The value is out of range OR Function