Hey Mr Chikasa Evans thank you for everything you have done, because of you I could solve the IGCSE 2017 feb/march Examination ICT papers both paper 2 and 3 very easily your tutorials helped a lot to me. I can't thank you enough. I wished I had a good teacher like you before .😊😊😊
respected sir, thank you so much to do this tutorials to help us in our ict exams, I have something to share is instead of writing all the formula we can go to formula then click on insert functions then we copy the table required for table array and the computer will set it.
thank you so much for the fast response sir, your viewers' concern is your concern, you uploaded it just in time ,I'm ready for my exam now,my doubts are cleared ,massive respect ,appreciated sir ,one of the best tutorials out there :-)
U have been a great helper Chikasa! Proud of people like u supporting education! My son ends his practical tmr...and whatever marks he gets is all on what u did to him!Stay safe evans..a great life to follow for u!
Thank you so much for every one of your videos, I have my ict paper 3 exam tomorrow and I had paper 2 two weeks ago. Your videos were super helpful and you have no idea how much I depended on them throughout my preparation. My teacher is a complete disaster and so you were my teacher because I learned from your videos. If I do well on my exams is all going to be thanks to you!!! Thank you so so so much!! You are amazing, kind, smart, funny and I hope I could have you as a teacher! I just wanted to take the time to thank you bc you deserve it!! Hope you keep on making this great videos for future examinations!!!
I thought VLOOKUP was vertical therefore the more columns you have is when you apply it .WhIle HLOOKUP is horizontal thus being applied when you have more rows.
The opposite is true. When you have more columns than rows, use HLookup and when you have more rows than columns, use VLookup. VLookup is vertical yes and HLookup is horizontal but the interpretation is what is different. More columns than rows means the data is arranged Horizontally and more rows tahn columns means the data is arranged Vertically.
hey Evans!! thank you so much for your videos.. had my ict practicals paper today and it was absolutely amazing all thanks to you and your videos.. THANK YOUU 😘❤
evans, god bless you man! i have my paper 3 preboards tomorrow and the whole day i was at your page but u didnt have the excel videos for oct/nov and i was disappointed going to cry but then like a miracle the much longed tutorial showed up. thanks alot
Thanks a lot Mr Evans Chikasa because of your paper 3 tutorials i was able to do my feb/mar 2017 examination paper really fast and it felt easy too. Once again all thanks to you sir.
Sir I watched one of your videos some time ago ..the day before my ICT Test and the paper you solved was the same paper that came in my test and I felt sooo happy and at the end I came first in my class so I would like to thank you so very much .Your tutorials are literally the best 💯✨✨
Hey Evans , your videos were a great help, they made practicals easier for me...The 2017 February March paper was extremely easy, all thanks to you and your efforts that helped me in my exam! Thank you so much!
thank youuu soooooo much! the way u make this fun and how ure teaching is not too serious im pretty entertaine, and uve explained things is particular cause im real beginner Ure a bless
hello mr chikasa can you please do videos just based on the functions and explain them for us instead of doing full papers because im not clearly getting the function
Hi Mr Chikasa, I have some questions about this section of this paper. 1) Why do we have to put an exclamation mark in the VLOOKUP formula? 2) Why do we have to put the absolute cell reference in the formula for cell A2 to B12? What would happen if I didn't put the referencing? By the way, thank you so much for uploading tutorials on practical papers, it helps me a lot. :)
1. You are accessing the filename/CSV file located in another sheet or workbook 2. Absolute referencing makings the cells you have selected to be the same even if you replicate the formula. If you dont use it, every time you replicate the formula, the cells adjust too. This is call relative referencing. Please check out my other videos and you will learn more
Hi just wanted you help you other students out in the first v lookup question for the other file you can get to the table value part and just go and select it in the other file and the formula transfers
One question: if i don’t do the VLOOKUP using the string (i mean searching it in the formula list) it is necessary to specify the document location/name or it is automatically done by the computer? GOOD VIDEO!
Thank u for this tutorial it really helped me but i have a question...i have all the headings on cell A1 and then the data in row 2 are all in cell B2 and all the other data the same i dont know what to do should i separate them un different cells?
im just telling evans when ur doing vlookup we may not need to write all of it...u can go to the other spreadsheet and select the table..everything comes...there might be a mistake typing everything
yes, there are many ways to do the Vlookup. I usually prefer doing the one for typing because it also acts as revision in theory exam for the student when they are asked about VLookup. The method for for selecting the table is also good but many students struggle with it in the theory exam when they do the Vlookup decoding so to say. Otherwise, thank you for all your positive and constructive feedback Santosh.
Evans Chikasa thank you so much sir!!! I would really appreciate. some of the questions in the past paper are a bit tricky and tough to understand for me. If you can make a video before the exams I would be enchanted.
Hey Evans today my ict paper 2 cie board exam is done actually in a report by mistake only half of my candidate name was visible and i realised after printing the report was of 14 marks so please can you tell me how many marks will be lost as there were 4 printouts of that report with half of candidate number now its really bothering me
@@talabashar9281 so I just did my paper 3 today. the currency will be put as a symbol , with the name of it beside it ($- US dollar) so you can search for that in cell format. No worries. Good luck
Hi, Sir Evans, I meant to ask a question about Excel. When I open my excel file, all of the fields are in one record, why? They are not arranged like yours
Great. It appears it has loaded as a CSV file. Will you kindly get a new resort.csv file in the video link above? I have included a link to the source files just below this video. Let me know what happens when you load this new file.
unfortunately I deleted them after I finished recording the video. I will upload the files for the 2017 February/March exam together with the uncompleted files since you have requested them
Why you are talking very fast plEASE try to reduce you"re speed while talking because some times i will MISS SO IMPORTANT POINTS .... SORRY FOR THIS COMMENT
U have been a great helper Chikasa! Proud of people like u supporting education! My son ends his practical tmr...and whatever marks he gets is all on what u did to him!Stay safe evans..a great life to follow for u!
Who would dislike this, That's pure madness
Hey Mr Chikasa Evans thank you for everything you have done, because of you I could solve the IGCSE 2017 feb/march Examination ICT papers both paper 2 and 3 very easily your tutorials helped a lot to me. I can't thank you enough. I wished I had a good teacher like you before .😊😊😊
Thank you for your kind words. Am glad I was of help
Came back to this post 7 years later, hope you are doing well and have finished school already.
@@EvansChikasa lol
respected sir, thank you so much to do this tutorials to help us in our ict exams,
I have something to share is instead of writing all the formula we can go to formula then click on insert functions then we copy the table required for table array and the computer will set it.
thank you so much for the fast response sir, your viewers' concern is your concern, you uploaded it just in time ,I'm ready for my exam now,my doubts are cleared ,massive respect ,appreciated sir ,one of the best tutorials out there :-)
Thank you Atharva
The life hack for VLOOKUP and HLOOKUP is SO helpful
AFTER WATCHING YOUR VIDEOS, I KNOW THE MEANING OF *TEACHERS* AND THE IMPORTANCE OF *GOOD TEACHERS* .
Agreed!
🤣😂
Thx my man. U saved me for my ICT test yesterday and for tmr I m kinda ready thx alot. U a hero without cape
U have been a great helper Chikasa! Proud of people like u supporting education! My son ends his practical tmr...and whatever marks he gets is all on what u did to him!Stay safe evans..a great life to follow for u!
Amen, thank you sir
How much did he get?
Thank you so much for every one of your videos, I have my ict paper 3 exam tomorrow and I had paper 2 two weeks ago. Your videos were super helpful and you have no idea how much I depended on them throughout my preparation. My teacher is a complete disaster and so you were my teacher because I learned from your videos. If I do well on my exams is all going to be thanks to you!!! Thank you so so so much!! You are amazing, kind, smart, funny and I hope I could have you as a teacher! I just wanted to take the time to thank you bc you deserve it!! Hope you keep on making this great videos for future examinations!!!
I thought VLOOKUP was vertical therefore the more columns you have is when you apply it .WhIle HLOOKUP is horizontal thus being applied when you have more rows.
The opposite is true. When you have more columns than rows, use HLookup and when you have more rows than columns, use VLookup. VLookup is vertical yes and HLookup is horizontal but the interpretation is what is different. More columns than rows means the data is arranged Horizontally and more rows tahn columns means the data is arranged Vertically.
You the best Mr Chikasa Evans! Thanks for all your help!
You are welcome and thank you for your kind words
first video i looked up today, already found you, gg m8
You are welcome
hey Evans!! thank you so much for your videos.. had my ict practicals paper today and it was absolutely amazing all thanks to you and your videos.. THANK YOUU 😘❤
You are most welcome. Am glad to hear you enjoyed the paper
Why do you put the table array like that when you can just copy it from the other file
Are v all gonna gonna write the exam tommorrow??
yass
All the best guys
evans, god bless you man! i have my paper 3 preboards tomorrow and the whole day i was at your page but u didnt have the excel videos for oct/nov and i was disappointed going to cry but then like a miracle the much longed tutorial showed up. thanks alot
You are welcome and enjoy the revision
YOU KNOW EVAN YOU ARE A LIFE SAVER AND YOU TAUGHT ME AND MY FRIENDS MORE THAN OUR ICT SIR
Hello, Mr Evans, the only reason why I will InshaAllah pass my exam today is that of you thank you so much and I love your videos
4:14 you can also select the first four rows right click and press insert
Thanks a lot Mr Evans Chikasa because of your paper 3 tutorials i was able to do my feb/mar 2017 examination paper really fast and it felt easy too. Once again all thanks to you sir.
You are most welcome. Am glad to hear you did well
Sir I watched one of your videos some time ago ..the day before my ICT Test and the paper you solved was the same paper that came in my test and I felt sooo happy and at the end I came first in my class so I would like to thank you so very much .Your tutorials are literally the best 💯✨✨
Thx a lot !! In today's paper i will score marks because of you ..
hope a great future for u carry on ..
Thank you Khan.
Always wlcm, but u should describe the Excel functions more in details 👍👍 i lossed marks in that part
i do the igcse in two weeks , thanks for your videos man
Hey Evans , your videos were a great help, they made practicals easier for me...The 2017 February March paper was extremely easy, all thanks to you and your efforts that helped me in my exam! Thank you so much!
You are most welcome. Am glad to hear you did well in your exams, it makes me so excited that my channel was easy
thank youuu soooooo much! the way u make this fun and how ure teaching is not too serious im pretty entertaine, and uve explained things is particular cause im real beginner Ure a bless
hello mr chikasa can you please do videos just based on the functions and explain them for us instead of doing full papers because im not clearly getting the function
you could insert rows faster by simply clicking the number of rows on the side then clicking insert rows
Omg thanks for this vid. I have an exam tomorrow and this is helping me alot.. omg thank u so mucb
Hi Mr Chikasa, I have some questions about this section of this paper.
1) Why do we have to put an exclamation mark in the VLOOKUP formula?
2) Why do we have to put the absolute cell reference in the formula for cell A2 to B12? What would happen if I didn't put the referencing?
By the way, thank you so much for uploading tutorials on practical papers, it helps me a lot. :)
1. You are accessing the filename/CSV file located in another sheet or workbook
2. Absolute referencing makings the cells you have selected to be the same even if you replicate the formula. If you dont use it, every time you replicate the formula, the cells adjust too. This is call relative referencing. Please check out my other videos and you will learn more
Thank you for your help I have a pre mock tomorrow and you really helped me a lot
Thank you a lot my boards is comming up in 1 and a half year and I’m starting from now
Thank you sir it helped me a lot to review my work.
you are so helpful i appreciate you very much
Hi just wanted you help you other students out in the first v lookup question for the other file you can get to the table value part and just go and select it in the other file and the formula transfers
Thanks Evans, these videos are so helpful. You explain everything and make it so clear. You are the best! :)
Thank you and you are welcome
thanks a lot!! I have my exam tmrw and this helped me a lotonce again thnx a lot! ur doing a great job keep going
I'hv got mine tomorrow too, all the best!!
Thank you very much for the support too
One question: if i don’t do the VLOOKUP using the string (i mean searching it in the formula list) it is necessary to specify the document location/name or it is automatically done by the computer? GOOD VIDEO!
u are god evans chikasa
Thanks you very much
This really helped me
Thanks for uploading before the exam
You are welcome
Thank you for this great help. I have an question that wether we could use frontnote in the exam???
paise is pronounced as peh-sei !...thanks for the tutorial!
Mr Chikasa. Is it possible to do February March 2016 paper 31 for IT using notepad. Not word front?
me entire class watches your videos
so you put exclamation mark because it is an external file?
Thank you so much for doing these amazing videos! Helps us a lot :)
You are welcome
this is amazing tku for helping
your video helped me big time! wish me luck for my exam tomorrow :D
You are welcome Karim. All the best in your exams tomorrow
The name Bardez isn't appearing. They are telling me the formula i typed contains an error!!!!
Thank u for this tutorial it really helped me but i have a question...i have all the headings on cell A1 and then the data in row 2 are all in cell B2 and all the other data the same i dont know what to do should i separate them un different cells?
...telling me that ' you got the indian rupees symbol correctly, and I was very EXCITED hehahahahahahahahaha'
im just telling evans when ur doing vlookup we may not need to write all of it...u can go to the other spreadsheet and select the table..everything comes...there might be a mistake typing everything
santosh mukherjee he's done that before... I think here he's showing another method of doing it.
yes, there are many ways to do the Vlookup. I usually prefer doing the one for typing because it also acts as revision in theory exam for the student when they are asked about VLookup. The method for for selecting the table is also good but many students struggle with it in the theory exam when they do the Vlookup decoding so to say. Otherwise, thank you for all your positive and constructive feedback Santosh.
Mr.Chikasa can u make a video about excel and explain complicated formulas?
Sure, I can do that
Evans Chikasa thank you so much sir!!! I would really appreciate. some of the questions in the past paper are a bit tricky and tough to understand for me. If you can make a video before the exams I would be enchanted.
Thank you
I have my exams after just 3 hrs so could anyone tell me if i would be allowed to use KompoZer in my Paper 3 in my Exams.(Official CIE Examination)
Thanks so much
Hi Evans I have a problem when ever I write the formulae this thing appear
I will sent it to on email
Amazing vid
Hey Evans today my ict paper 2 cie board exam is done actually in a report by mistake only half of my candidate name was visible and i realised after printing the report was of 14 marks so please can you tell me how many marks will be lost as there were 4 printouts of that report with half of candidate number now its really bothering me
You will probably just loose 4 marks of that. 1 mark for each print out
thank you soo much sir!!!!
Can you plz make a tutorial on May June 2015 Paper 3 Data Analysis
I just wanted to ask, do we have to put the currency symbol, like what if I didn't know it?
usually it tells you on the question paper how the symbol looks like.
random guy okay thank you
@@talabashar9281 so I just did my paper 3 today. the currency will be put as a symbol , with the name of it beside it ($- US dollar) so you can search for that in cell format. No worries. Good luck
random guy ya i did mine today too and they just told us euros so it was really easy to find as i think it’s the first one
Please show the link add video and audio files. i am not able to find it
check this one th-cam.com/video/GPoZCcpzPkc/w-d-xo.html
Hi, Sir Evans, I meant to ask a question about Excel. When I open my excel file, all of the fields are in one record, why? They are not arranged like yours
Hello Your Senpai, will kindly show me a screeshot
I sent it to your e-mail.
Great. It appears it has loaded as a CSV file. Will you kindly get a new resort.csv file in the video link above? I have included a link to the source files just below this video. Let me know what happens when you load this new file.
I loaded the new file and it is still the same.
How are you opening the file? Try to right Click on it and open with Excel
WHeres the part 2
legend
How to add videos and audio in frontpage?? plz reply fast!!
Check my video list, I did one on that
WHere??? I cant find. Please give the link
Check here th-cam.com/video/GPoZCcpzPkc/w-d-xo.html
todays paper3 was so easy
Jeet Chudasama u'll get full?!
when do we use absolute reference?
When the cells you want to refer to wont change through out the running of the spreadsheet program
where is website authoring for this paper?
th-cam.com/video/e-zWOkJd2SM/w-d-xo.htmlsi=wM3qJkEBMRqaUggq
Hi Mr Chikasa, could you also link the completed files please. It would help me a lot. Thank you.
unfortunately I deleted them after I finished recording the video. I will upload the files for the 2017 February/March exam together with the uncompleted files since you have requested them
Thank you!
you skipped question 15 font
Calibri is a sans-serif font, so it is still perfectly fine. I should have mentioned it anyway. thanks for that
Excuse me Mr Chikasa Sir please reply to me on the discussion
I replied
Could you please show how to solve 2015 February March paper 31?
It is already uploaded. Check the playlist
I am sorry. I checked twice but could not find it.
I think the 2015 is not uploaded. It is the 2015 Feb/Mar that is uploaded. I will try to do it in the coming weeks.
Sir, could you please give me your e-mail id because i want to e-mail you the paper that i want you to do?
inbox me on the channel email or better even post it here I dont mind
where is the web authouring ??!
Try to check on the list. All the videos for this paper have been recorded
Why you are talking very fast plEASE try to reduce you"re speed while talking because some times i will MISS SO IMPORTANT POINTS .... SORRY FOR THIS COMMENT
his accent is too slow
Gucci video
it is pronounced peh say (like the pe in pear)
Awesome, thanks Aaruan
r u jesus, cuz ur too kind
who's having ICT paper 3 tomorrow?
17/10/18
meeee
Paise its pronounced like "pa-ee-sey"😂😂😂😂😂
Paise
U have been a great helper Chikasa! Proud of people like u supporting education! My son ends his practical tmr...and whatever marks he gets is all on what u did to him!Stay safe evans..a great life to follow for u!
Thank you Santosh, many thanks for your kind words and advices on my channel. Am grateful for the support.
Evans Chikasa last question evans do u teach A level?
Yes, I teach Computers Science A-levels. My school hasn't yet start offering ICT A-levels. We offer ICT just at IGCSE
Paise