Step by step exercise. Introducing data. (IV)


Step by step exercise.

 

We willnow use references to other cells and text operators.

8 Write The in cell E1.

9 Write house in cell E2.

We want to write the concatenation of cells E1 and E2 in cell E3.

10 Write =C1&C2 in cell E3.

Observe how the concatenation of the contents of the mentioned cells appears. It would be better if we left a blank space between the two cells.

11 Write =C1&" "&C2 in cell E4.

12 Write =C1&" white "&C2 in cell E5.

The numeric values can also be concatenated.

13 Write =C2&A4 in cell E7.

14 Write =C1&12 in cell E8.

We will now move to studying the relational operators.

15 Write =10>12 in cell F3.

Excel returns the TRUE value if the comparison is true and FALSE if not. In our example we ask if the value 10 is greater than the value 12, and so it is False. This will be the value that appears in the cell.

15 Write =A1>1 in cell F4.

The result will be true as the contents of A1 (1000) is more than 1, and so the True value will appear in the cell (the column will be automatically enlarged so that it fits).

16 Write =A1=A4 in cell F5.

Excel checks whether the value in cell A1 (1000) is equal to the value in cell A4 (12), and so it is false.

We will now study some of the predefined Excel functions.

We want to write the value 10,123 rounded off to the nearest 1 decimal in cell D1. For this Excel has a function called the Round function and whose parameters are: the first is the value to round, a point and comma (as parameters seperator) and then the number of decimals to which you want to round the number off to.

17 Write =round(10,123;1) in cell D1.

Observe how the desired result appears in cell D1..

References to other cells can also be used.

18 Write 10,123 in cell D2.

19 Write =ROUND(D2;1) in cell D3.

Observe how the result is identical to that in cell D1.

We now want to add the contents of cells A1, A2, and A3.

20 Situate yourself in cell A7.

21 Write =A1+A2+A3

22 Press ARROW DOWN on the keyboard.

Another way to accomplish this consists of using the Excel SUM function, which often uses reference operators (to indicate a set of cells).

23 Write =SUM(A1:A3) in cell A8.

That tells us that they are going to sum the contents of the set of cells starting with A1 and ending with A3 (A1, A2, A3).

24 Press ARROW DOWN.

25 Write =SUM(A1:A4;A7) in cell A11.

This is the equivalent to the operation =A1+A2+A3+A4+A7.

26 Press ARROW DOWN.

27 Write =SUM(A1:D3) in cell A12.

This is the equivalent to the operation =A1+A2+A3+B1+B2+B3+C1+C2+C3+D1+D2D3.

28 Close the workbook without saving the changes, that is:

Click on the Close button on the menu bar.

We will be asked whether we want to change the changes made (this is explained in the next theme).

Click on the No button.

 

 



   
     
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.