 |
It is possible to store the mind with a million facts and still be entirely uneducated. - Alec Bourne |
 |
|
|
||||||
TYPES OF DATA:We are discussing four types of data. Labels, Values, Formulas and Functions. LABELS always begin with a letter (A-Z, a-z) and are used for headings, titles and text type of info. examples: FUNCTIONS:are built in routines designed to perform a specific task, and always begin with an ='s sign. examples: The IF function is used to test a condition to see if its true or false. One action is taken if the condition is true, and another if the condition is false. examples using the IF FUNCTION... Excel will test to see if A1 is greater or equal to 60. if A1 is greater than or equal to 60 then the word PASS will be placed in the cell where the function is being entered. If A1 is less than 60, the word FAIL is placed where the function is being entered. Excel tests to see if A1 is greater than 100. If it is, the value of A1*10 will be placed in current cell, if A1 is less than 100, then the result of A1*5 is placed in the current cell. Remember, if you want text to appear in the cell if the condition is true/false, the text must be enclosed in double quotes.
Comments:
|
|
|||||||||||||||||||||||||||||||||||||
