• We need your support!

    We are currently struggling to cover the operational costs of Xtremepapers, as a result we might have to shut this website down. Please donate if we have helped you and help make a difference in other students' lives!
    Click here to Donate Now (View Announcement)

IGCSE ICT HELP

X

XxChampXx

Messages
273
Reaction score
83
Points
38
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
 
A

ahmedA

Messages
25
Reaction score
11
Points
13
XxChampXx said:
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
Click to expand...
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
 
X

XxChampXx

Messages
273
Reaction score
83
Points
38
ahmedA said:
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
Click to expand...
Now I understand. Thank you so much.
 
X

XxChampXx

Messages
273
Reaction score
83
Points
38
ahmedA said:
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
Click to expand...
Are there any other formula's like this that we have to learn?
 
A

ahmedA

Messages
25
Reaction score
11
Points
13
XxChampXx said:
Are there any other formula's like this that we have to learn?
Click to expand...
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....
 
A

ahmedA

Messages
25
Reaction score
11
Points
13
ahmedA said:
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....
Click to expand...
my paper 2 is on 13 and 3 on 18th
 
X

XxChampXx

Messages
273
Reaction score
83
Points
38
ahmedA said:
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....
Click to expand...
Thank you
 
You must log in or register to reply here.
Top