IGCSE ICT 2016 May June paper 32 Data Analysis Excel

Download the files here www.dropbox.com/s/ihmt0h9gdtg...
In this video I solve questions from the IGCSE ICT May/June 2016 paper 32 exam, a section on Data Analysis.

[@mr.bronzie4875]

Thank u so much, evan's wife, for allowing him to stay up late to save poor students

[@SharkRockstar]

@2308ARY OMG FR?

[@samasherif1884]

@@ozairbaigg SLAAYYY

[@eslamonthevlog]

5 years later, you are prolly in the 20s ? there is some kid who turned 15(turns 16 in march) and is being saved right now just like you were saved 5 years ago

[@wintersongxx]

​@@eslamonthevlog same, except I'm15 turning 16 next year

[@agtaliengamingthailand426]

Best ICT teacher helping poor students suffering from ICT

[@hansenk.123]

FACTS!!!!!

[@matrixigtgamer8163]

Facts

[@umairAli-bt6wc]

Not all heroes wear capes, Mr. Evans Chikasa is the best example and my hero who saved my grades (hopefully). (my exam is tomorrow....im so nervous...)

[@abdullahshafiq4655]

u will fail

[@BEKZzY]

abdullah shafiq stfu

[@FernsDrummer]

Did you pass? BTW my exam is tomorrow!

[@anomaly_echelon7994]

@@FernsDrummer same here today

[@FernsDrummer]

@@anomaly_echelon7994 Don't worry! It will go fine!

[@shaheer_04]

Thank you Mr. Evan's boss. Your tutorial is still valuable 5 years later!😎

[@sweaty_sadiq]

6 years

[@zaidbaidas1406]

​@@sweaty_sadiqhe wrote it 2 years ago

[@sweaty_sadiq]

No one cares lil bro@@zaidbaidas1406

[@blueepeas3268]

Lol, Chikasa has the best wife

[@blueepeas3268]

Yep:))

[@blueepeas3268]

@Anjal Krishna there was another comment here but it looks like they deleted it. I had replied to that comment with a "yep!". Lol 😂

[@sepsgc5548]

my test’s in 20 mins, I’m so glad this video helped me understand so much!!

[@manavpatel8866]

thank you very much for this video because tomorrow we have boards and from this video I have understood the excel functions

[@EvansChikasa]

Am glad to hear that. You are most welcome

[@manavpatel8866]

sir can you give me some tips about solving the excel part easily

[@alithecoolkidd]

thnx a lot but ur laugh makes me laugh. good really and u r the only one who soes these videos so respect to u.

[@ARJ_07]

kannada movie hombisalu

[@madhurshinde4988]

sir i used if functions and still got the right answer =IF(F17=1,"Full time",IF(F17=0,"Not Started",IF(1>F17>0,"Part time",0)))

[@Hehexddddd]

ppl watch your vids to learn... i watch to laugh xD . your laugh makes me laugh

[@SuperSweetielove12]

tHank yOu so much for the thorough explanation! My exam's tomorrow & binging your videos have been EXTREMELY HELPFUL. ((thanks to ur wife too))

[@EvansChikasa]

Hahaha, you are most welcome. I will tell her

[@nixieshah04]

Hi Mr. Evans! I actually discovered you couple of days ago. My term exam paper 2 was today and you were SUCH A HUGE HELP, though i did miss up in access. Anyways, when i found out that my friends watched your vids too i was like OMG. You are a really, really great teacher Mr. Evans! I hope I can do better on my Paper 3 exam this Monday!

[@FPLogistic]

Dude I was so confused on wtf to do and you just helped me so much. God bless you!

[@yanchernchong5017]

I think I will ace my ICT. Thank you so much!

[@EvansChikasa]

You are most welcome

[@soldaystar1739]

thank you very much Mr Chikasa for all videos you have uploaded. Thank you Mrs Chikasa for allowing him to teach us. I'm really grateful for all and may the Lord God almighty bless you

[@mussabbinimran5265]

thank you Mr. Evans I have my may june 2017 paper 32 tomorrow and this really helped me. Thanks again and may god bless you good sir.

[@saxtee]

Thank you Ma for allow him to make this recording and thank you sir

[@deepashinde9208]

i know this video is old but if youre reading this a biggggg thank you to you today i had my pracycal exams and i dont know what i could do without these videos

[@NightLightBS]

bro you're legit a life saver, tysm for these videos

[@jsdcvud7834]

Thank you very much for the video and files that you left in the description!

[@itzooni]

I had my ICT P2 today it went really well, all thanks to your videos :))

[@jansenlimawan8415]

Holy cow, thank you! Clear and easy to understand!

[@yousefsuhil5657]

thank u u r way more better than my shit teacher ....now i understand all functions .... thank u very much brother!!!

[@FernsDrummer]

Its okay brother some teachers are shit!

[@TU-lq7jw]

i am telling ur teacher

[@michaelchicken472]

OMG ITS NOT ONLY ME WHO HAS A SHIT ICT TEACHER, BUT MINE IS WORST I GOT 2 A PRIVATE SCHOOL AND MY TEACHER IS THAT SHIT

[@Silent_005]

bro das fax

[@tariqfadl6934]

Really helpful !! Surely this will aid me in my IG exam , 10 days from now !

[@hisimsim]

We just finished our practicals today- and they went well! Thank you for the videos :D They were a great help

[@EvansChikasa]

You are most welcome

[@alial-dorzi6886]

Thank you for your extraordinary efforts.. You are truly a life saver!!!!

[@EvansChikasa]

You are welcome

[@olaaaaaa7671]

you are amazing chikasa !! , keep saving our lives

[@emansaeed3282]

The way you explain things is priceless!

[@EvansChikasa]

Thank you Eman

[@0bada905]

Ur awesome!!! My ICT teacher doesn't teach us how to write the codes. He only makes us use the dialogue box to enter the functions.

[@samitubehd8157]

You Are the best i have my CIE board exam for paper 2 with includes excel and share point thanks brother!

[@abdullahimad6571]

can you show me how to use vlook up function using FX because I get confused with it

[@pranaisuwan6442]

Av Exam Tomorrow, Many Thanks Evans. I won't fail as badly now thanks to you.

[@alexiscunningham9944]

Thank you so much Evans!! You've helped us a lot with our igcse ict exams!! Especially on Tuesday, the paper was a good one, nothing too difficult. Hopefully next Tuesday's paper is the same :)

[@maryamafzali7202]

your having exam on 18 oct?

[@chiomaolaraonye8757]

i am

[@EvansChikasa]

You are welcome, am glad you did well in the paper

[@jana7504]

Mr Chikasa , allow me to tell you that you are a life saver . My practicals are in 10 days and your videos are so helpful !

[@Ali-ur3et]

Thanks man this really helped me out,cheers to you!

[@hasitparikh5878]

Helped alotttt..... You are certainly doing a good job by teaching us through this platform.. thankyousomuch

[@EvansChikasa]

You are welcome

[@kashyapmangathaya4173]

Thank you for this video Evans, it really helped in me securing higher marks in my board exams, thanks to you. These videos were really awesome at explaining the uses of the functions, as excel used to scare me!

[@EvansChikasa]

Thank you for that feedback and you are most welcome

[@giftchimanishachanda8588]

I'm a Zambian watching this in Ghana.i just wanna say your tutorials are helpful!keep it man

[@EvansChikasa]

Thank you and you are welcome

[@sadhvianand8239]

thank you vry much i saw your access vid and i scored well i havent looked at any other ict teaching videos after yours

[@vaibhavponnapalli881]

Thank you sir. Your videos are just making me rock in the class. To be short, you are awesome

[@EvansChikasa]

Thank you and well done

[@zexbissyt7149]

Thank you so much, i now understand how and where to use the different formulas.

[@AyshaFilms]

this helped so much. im having ict igcse this april!

[@baselmq4609]

thank you i took my paper2 exam yesterday .. it was easy ... i will take my paper 3 tommorow .. thank you you helped me more than my teachers 💕💕

[@mary-ox4rr]

ilysm mr evans your the best ict teacher in the universe

[@rafiazari1617]

your videos helps me a lot in my exams thanxx

[@mimiaahh]

Thank u so much sir my mock exam is in 2 weeks so this really helped me out alot!!!

[@siddharthnamdeo6967]

again as i say you really deserve a like and here you go

[@kunalnihalaney1793]

Thanks alot bro

[@EvansChikasa]

You are welcome and thank you for the complement

[@humairtahseen4961]

U actually are the best IT teacher I have come across can u please do data analysis on excel 2010 it will be great and majority of student are doing exam in excel 2010

[@aiz-tv]

Thank you soo much!, this helped a lot. I am gonna tell all of my friends about your channel , because your videos are really helpful.

[@EvansChikasa]

Thank you so much for the support you are rendering to this channel

[@saqraburokbah2969]

Thank you so much Evans Chikasa best teacher in the world

[@al-najjar6642]

THANK U SO MUCH SIR YOU HAVE HELPED OUT SO MUCH TODAY, YOUR LAUGH IS SO WHOLESOME HAVE A GOOD DAY

[@mohsinbiswas143]

Hi thank you for the great video . i have only one question - what i do for the print is that i go to page break view and select the area for printing for each page so that makes it like in 2 paper sheets. is that fine ? also if i dont change the row and column headings and potrait for the second printout will it still be ok or will i lose marks?

[@ntandodee8031]

what if you use the function tab for the V-lookup?

[@samyakjain4046]

thanks Chikasa,this video really helped me a lot

[@samito22]

Thanks too much, the best teacher!

[@saimrehman.7]

thanks alot evans......your videos have helped me alot for my preparation for my igcse board exam...which is on the comming thursday..whish me luck..and thank you again so much.

[@EvansChikasa]

Hello Saim, am glad to hear that. I wish you all the best in your exams

[@NightLightBS]

how was your exam bro

[@imaginebreaker]

Thank you so much! you have saved my life!

[@EvansChikasa]

You are welcome

[@alanrome5490]

sometimes there are two formulas that can be used right? and it'll still give the same answer, so when they ask to print the spreadsheet with the formulas showing, do they only look for specific functions that are given in the mark scheme?

[@qaimaali6546]

What a lesson I laughed soo much during this session Helped me a lot Thanks alot

[@EvansChikasa]

Hahaha, you are welcome

[@raheegosama8595]

Evans Chikasa your are amazing i literally watch you videos thanks for helping me especially

[@EvansChikasa]

You are most welcome

[@raheegosama8595]

hi i am really interested in your work don t have other paper for different years thanks for you amazing videos

[@aishayousif6969]

Such a life saver

[@boyedwalker7370]

Hallo sir it is coniah gxotelwa form your Class.i have been watching your videos and it’s been helping a lot

[@EvansChikasa]

Hi Coniah, great to hear from you. It has been a while. How are you doing and where are you?

[@ashraftalaat910]

you are amaziing you helped me so much

[@yashshah940]

Thank you for helping all of us :D

[@anasshweki1054]

wooohooooo you are a legend... if only we had you in our school :))

[@hodaprince7392]

man you are the best thank you very much

[@EvansChikasa]

You are welcome

[@advaithdeepu7764]

you actually pronounced 90% of the names without any problem :)

[@auray-7393]

Thanks for the help man!

[@nignog586]

I loved your video. Thank you very much and you are also very funny XD!!!!!!

[@tnm-beast9257]

Thank you sir😃.Really helped me a lot😍😍😍

[@Ibrahim.ak03]

55:34 how did u opened the window find and replace

[@AG-su1uk]

Ik this is late but how do you Centre align text in footer, or is it automatically aligned?

[@thatoanyangoomondi7243]

Thank you so much this was really helpful!!

[@EvansChikasa]

You are most welcome

[@bilalkirmani6005]

wallah i love you so much ur the best ict teacher

[@aryanmistry3063]

Love ur vids I am going to score A* now!!!! Wakanda forever

[@ahmedabbas5652]

that's little bit racist

[@shahdhetta7967]

So useful, that helped me so much thank you

[@mustafayesil2644]

love your videos

[@rabiyakhan716]

May God bless you!!!!!!

[@nujodhola550]

Ur the besttt❤️❤️❤️❤️

[@lpc7114]

thank you so much evans

[@AhmedSamir-ks6bp]

Mr. Chikasa Evans I have a problem on the absolute reference when I am pressing f4 my computer doesn't add the dollar signs

[@EvansChikasa]

Your F4 button could be configured for something else. Just type it in

[@ayan1826]

My exams tomorrow and I just started studying thx to ur vid

[@residental4331]

why did you use lookup function and not vlookup in the second lookup function and if i used vlookup will it be wrong

[@micheal2124]

😂 thank you so much you make learning fun and the way you keep laughing and mentioning your wife lol

[@EvansChikasa]

You are most welcome... and thanks for the compliment

[@arjeshmukherjee1488]

ur really a life saver Thanx alot 😃😃😃

[@EvansChikasa]

You are welcome

[@tusharmallisetty4857]

thanks. this really helped a lot

[@shailenderkalia8344]

best teacher you helped a lot................... thxns love from india

[@EvansChikasa]

Thank you very much

[@alejaposada7994]

saved my life luv u

[@lovepreetkaur4595]

Thanx alot sir. It really helped alot.

[@sheepbow909]

The fact that he teaches in a right way while also keeping entertainment on is something rare from channels like these, you are a underrated teacher and deserve more subs >:3

[@daniyalfarooq2784]

you are the best

[@Qpac524]

i tried to use vlookup, it works for some values and doesnt work for some; and then i found out that the lookup value should be i ascending order, so i did that, and it still doesnt work, pls help :'(

[@joshuagonsalves6275]

Thank you Evans Chikasa

[@PunyapratapsinghChauhan]

Thanks alot mam sir is of alot of help.They are truly wondurfull tutorials

[@EvansChikasa]

You are most welcome

[@mustafayesil2644]

Thanks a lot for the tutorial. I have CIE exams of paper 32 tomorrow, so your videos are really helpful. Excuse me for my crappy english. Also keep up the wonderful work.

[@PremierAlanMC]

Mustafa Yesil same your english is good lol

[@mustafayesil2644]

Thank you. Also I did my IGCSE ICT paper 32 today, it was easy I hope that I get A or A*.

[@nidalashhab2875]

how when u open the other excel file {job description}u can see the vlookup command on the top,do u just open a different file from excel and it will work?

[@EvansChikasa]

Hello Nidal, thank you for the comment. However, i dont quite understand your question, please forgive me! May you kindly rephrase it.

[@wallamustafa3811]

Thank u very much !

[@mustafaawan3168]

Thank u Evan I had a gr8 Paper

[@THEO-np1fv]

God bless you & your wife

[@redwne1013]

I am getting errors when doing the Annual Salary column when it comes to multiplying it to numbers which are not 1 or 0. Please help.

[@fionarimba5913]

The function for Annual Salary does not work on some of it that has decimal for Works. What do you think is the problem, sir?