## Text

### Welcome to the ICT Time

In this blog you will find useful ICT exercises, practical exam questions and much more.

The solutions of the Chapter 4 (Word Processing) exercises in ICT book. Solutions are included.

The solutions of the Chapter 5 (Spreadsheets) exercises in ICT book. Solutions are included.

### Database Exercise solutions. Coming Soon...

Video Tutorials will be here soon.

### All tech and school news

Articles and news.

## Tuesday, 27 November 2012

### Absolute Cell References With Exercise 5.5

Previous post I discussed relative cell referencing with Exercise 5.4 Here I will talk about absolute cell referencing.

Relative cell referencing is very useful in many cases by adjusting the cell references when a formula is copied from but one location to another. Example can be seen here.

There might be times that you need to use one cell in each formula. To prevent Excel to copy all cell references we use Absolute cell referencing. In Excel these formulas are constructed by placing dollar  (\$) signs in the cell reference.

#### Check this simple example video.

Here I made a simple currency converter. From US Dollars to Malaysian Ringgit. Let's say 1 dolar = 3.02 Ringgit. I simply put this information in cell D1 and I write different amounts of dollars in column C. Ringgit currency is calculated in column D. Just pay attention how the Absolute cell referencing is used in formulas. When we copy the formula we can see that cell D1 never changes in copied formulas.

## Saturday, 24 November 2012

### Exercise 5.4

This exercise is mostly about Sum function. Sum function is used to add the selected cells. In Sum functions we use cell references by this way any change which is done to the cells will take effect immediately. Notice that the formula that we entered in cells E6, E7, E8 and E9 are very similar except that the row numbers are different.
In the video i wrote the formulas one by one but instead of entering the formulas one by one , a spreadsheet will let us enter one formula and copy this to the other cells and it will adjust the copied formula. This feature is called relative cell addressing. In the next post I will talk about Absolute cell references.

## Wednesday, 21 November 2012

I will keep it simple here.

Formulas are made up from math operators (+, - / , *), cell references(A1,B1,C23,...) , functions(sum, Average,...).

Here is a table;

 OPERATOR DESCRIPTION EXAMPLE IN EXCEL COMMENT + Addition =B2 + B4 Adds the contents of cell B2 to B4 - Subtraction =D8 - D5 Subtracts the contents of cell D5 from the contents of cell D8 * Multiplication =C4 * B4 Multiplies the contents of C4 with B4 / Division =A3/B3 Divides the A3 by contents of B3 ᴧ Exponentiation = B6^2 Squares the contents of Cell B6