IGCSE ICT HELP

[XxChampXx]

Hi,
In the oct nov 2014 paper, there was questions in which we had to use the 'LEFT' function in paper 3 excel part. This formula was completely new and was not asked in any of the past papers. Are there any other formula's I have to know other than the LEFT function which is not mentioned in the syllabus.
Thank you in advance for your help

 

[ahmedA]

Hi,
In the oct nov 2014 paper, there was questions in which we had to use the 'LEFT' function in paper 3 excel part. This formula was completely new and was not asked in any of the past papers. Are there any other formula's I have to know other than the LEFT function which is not mentioned in the syllabus.
Thank you in advance for your help

left function makes u get the first specified number of letters of a cell,like for an example u have the word purchase in A1 (better try it now while reading this,type purchase),then use the formula =left,then specify the cell which will be A1 in this case then comma then the number of letters u want like PURCHASE,,,,,,,,=left(A1,2) this will give u PU and if u type =left(A1,3) will give PUR

 

[XxChampXx]

left function makes u get the first specified number of letters of a cell,like for an example u have the word purchase in A1 (better try it now while reading this,type purchase),then use the formula =left,then specify the cell which will be A1 in this case then comma then the number of letters u want like PURCHASE,,,,,,,,=left(A1,2) this will give u PU and if u type =left(A1,3) will give PUR

Now I understand. Thank you so much.

 

[XxChampXx]

left function makes u get the first specified number of letters of a cell,like for an example u have the word purchase in A1 (better try it now while reading this,type purchase),then use the formula =left,then specify the cell which will be A1 in this case then comma then the number of letters u want like PURCHASE,,,,,,,,=left(A1,2) this will give u PU and if u type =left(A1,3) will give PUR

Are there any other formula's like this that we have to learn?

 

[omarkamel]

guys when are u giving ur practical exam and which variant kindly reply me inbox or on ma mail [email protected]

 

[XxChampXx]

guys when are u giving ur practical exam and which variant kindly reply me inbox or on ma mail [email protected]

Paper 2 on 13th and paper 3 on 15th...you?

 

[ahmedA]

Are there any other formula's like this that we have to learn?

no problem, well there are similar functions like mid and right functions, there are few exceptions for mid,but u can use use the help.(u can press F1 to open help box.) and other general functions you should know like average,maximum,minimum,etc....

 

[ahmedA]

no problem, well there are similar functions like mid and right functions, there are few exceptions for mid,but u can use use the help.(u can press F1 to open help box.) and other general functions you should know like average,maximum,minimum,etc....

my paper 2 is on 13 and 3 on 18th

 

[malk mohamed]

me too

 

[XxChampXx]

no problem, well there are similar functions like mid and right functions, there are few exceptions for mid,but u can use use the help.(u can press F1 to open help box.) and other general functions you should know like average,maximum,minimum,etc....

Thank you

 

[JohnPierre56]

ict only left wat to do

 

[JohnPierre56]

WAT MY TEACHER SAID PAPER 2 AND 3 ON 25 APRIL R U KIDDOMG