Step by step exercise. Introducing data. (III)
Step by step exercise.
51 Situate yourself in cell C5 and write 10AM
52 Press ENTER
Be careful, if we do not leave a space between the hour and the symbol, Excel will accept it as text.
53 Situated in cell C5, write 10 Am
54 Press ENTER
55 Situate yourself in cell C7 and write 1/1/95 1:1
56 Press ENTER
You can see how Excel also permits the introduction of a date and time simultaneously, and if they do not fit in the cell the column will automatically enlarge.
57 Situate yourself in cell C8 and write 12/12/95 12:30
58 Press ENTER
59 Situate yourself in cell D1 and write House.
60 Press ENTER
This is text type data that Excel wutomatically alignes to the left.
61 Situate yourself in cell D2 and write The Excel Worksheet
62 Press ENTER
On the introduction of text you will see how it occupies more than one cell in the sheet, D2 and E2. Text type data can occupy more than one cell in the sheet as long as nothing is written in the occupied cells.
63 Situate yourself in cell E2 and write Man
64 Press ENTER
It seems as if part of the text in cell D2 has been deleted, but this is not true, what has happened is that the contents of cell E2 hide part of the text in D2, but does not erase it. If we situate ourselves in cell D we observe its contents in the Formula bar, and see that it has not been erased. To solve this problem we can simply extend the width of cell D2, but this will be covered ahead.
65 Situate yourself in cell D3 and write large
66 Press ARROW DOWN on the keyboard.
The curser will move automatically to the cell below D4
67 Write The Excel worksheet that we studied corresponds to the XP version in cell D4.
68 Press ENTER
Observe how the introduced text occupies various cells in the Sheet although the text actually belongs to cell D4.
We will now practice the introduction of formulas.
1 Clic on the Sheet2 tab.
2 Situate yourself over cell A1 and write =1200+12 to add 12 and 1200.
3 Press ARROW DOWN.
Dont forget to always start the formula with the "=" symbol.
You will see that the result of the previous operation or formula appears in the cell, while the formula introduced appears in the Formula bar.
4 Write =11-10 in cell A2 to deduct 10 from 11.
5 Write =13*2 in cell A3 to multiply 13 by 2.
6 Write =24/2 in cell A4 to divide 24 by 2.
7 Write =10^2 in cell A5 to perform the operation of 10 to the 2nd power. If the ^ symbol does not appear when you press the key it is not a problem, it will appear when you introduce another character.
We will now use references or other cells and arithmetic operators.
We want Excel to perform the sum of the contents of cells A1 and A2 in cell B1.
8 Write =A1+A2 in cell B1.
On the introduction of the previous formula you will see how the result of the previous operation will appear in the cell, but the introduced formula will appear on the Formula bar. In this way, if we modify the value of cell A1 and/or A2, Excel will automatically recalculate the formulas that contain references to the modified cells.
9 Situate yourself in cell A1.
10 Write 1000
11 Press ENTER
Observe how the result in cell B1 is also modified.
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.