Step by step exercise. Introducing data (II)

 Step by step exercise.
 21 Without moving the cell, write 0 12/12. 22 Press ENTER Excel automaticall calculates the value of the fraction. If the result corresponds to an integer number, Excel will put this value in the cell and in the Formula bar. 23 Situate yourself in cell A11 and write 0 1/3 24 Press ENTER Excel writes the fraction (1/3 in the cell, but the final result of the fraction appears in the Formula bar (0,33333333333). 25 Situate yourself in cell A12 and write 0 12/24. 26 Press ENTER In case of being able to simplify the fraction, Excel will automatically do this to show it in the cell, that is, the simplified fraction will be put in the cell (1/2), and in the Formula bar the result of the fration (0,5). 27 Situate yourself in cell B1 and write 1/1/1900 28 Press ENTER This is a date type data. Notice how it is aligned to the left when introduced into the cell, just as with numbers. 29 Situate yourself in cell B2 and write 12-12-1900 30 Press ENTER You can see the dd/mm/yy format is assigned by default when it is introduced into the cell, that is, two digits for the day, two for the month, and two for the year, all seperated by a leaning bar. 31 Situate yourslef in cell B3 and write 1/1/2000 32 Press ENTER It may seem that Excel does not distinguish between centuries with the default format, but we will see ahead that it in fact does distinguish, but is just not always shown this way, and if we look at the Formula bar we see that the contents are still 1/1/2000/   33 Situate yourslf in cell B4 and write 12/13/1994 34 Press ENTER As month 13 does not exist, Excel introduces the date as if it were text and not a date, and this is why it is aligned to the left. 35 Situate yourself in cell B5 and write 30-02-1994 36 Press ENTER As this is also an erroneous date Excel introduces it as text too. 37 Situate yourself in cell B6 and write 12-MAY. 38 Press ENTER Excel will place the introduced date into the cell, but only using the first three characters of the month. The date will also be added to the formula bar with the dd-mm-yyyy format, taking the year from the computer system. 39 Situate yourself in cell B7 and write 12-may-1995 40 Press ENTER The date introduced will appear in the cell with two digits for the day, the first three characters for the month, and two for the year. 41 Situate yourself in cell B8 and write may-1995 42 Press ENTER The first three characters of the month and two for the year will appear, and in the Formula bar the introduced date will appear taking 1 as the day. 43 Situate yourself in cell C1 and write 0:0 44 Press ENTER This is a time type data. It is also automatically aligned to the right. 45 Situate yourself in cell C2 and write 12:30:12 46 Press ENTER 47 Situate yourself in cell C3 and write 22:12 48 Press ENTER 49 Situate youself in cell C4 and write 10 pm 50 Press ENTER 10:00 pm will appear in the cell, but in the formula bar the time will appear as 22:00:00. Continues on the next page...
 Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.