Text

Welcome to the ICT Time

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

Click here to go to the Video Solutions

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

Click here to go to the Video Solutions

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

Adding Formulas to a Spreadsheet

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

Introduction to Spreadsheets

Here I want to start Spreadsheet section with a little bit of explanation guys.

A spreadsheet enable you to deal with numerical data. Many financial models and many calculations carried out using spreadsheets.

In our tutorials we will start with the very basics of spreadsheets and I will try to cover all IGCSE topics and also I will try to add some more advanced topics about spreadsheets.
For our exercises I will be using Excel 2010 but most of the spreadsheet software out there will work similarly, so if you are using another spreadsheet software I don't think you will have problems following the solutions.