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.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited.
November-2005.