that is from the recording software that indicates the window is being recorded. Looks like instead of recording window it recorded the selected area which was nearly the whole window and as a result the outline of the selection was part of the recording. Yes if you pay attention to it, it can drive you nuts. cover it up to save your sanity :)
Yes it is. Here is the link to the syllabus 2023-2025. Look at section 15.1 chrome-aj/www.cambridgeinternational.org/Images/595352-2023-2025-syllabus.pdf
hi, in my recent paper i used count ifs in one of the formulas but my teacher told me it isnt part of the igcse syllabus. could you please let me know if i will be given marks for that or not
the syllabus states counting and countifs is a counting function. The syllabus does not state individually the counting functions like count, counta or even countif but they are identified in the mark scheme so you are good.
The AND statement allows you to check multiple criteria. It will only return true if all the criteria is met. For example: If you want to buy a car, you go to the dealer and you give your criteria. Let say you only give one criteria which is: price is more than 5000 (>5000) then ,the dealer will show you all the cars which cost more than 5000 if you want to give 2 criteria because some of the cars he is showing you are very expensive and you don't want to spend more than 10000, then you want this to be ANDED (AND) together, for example: price is >5000 AND 5000, price
![Excel Charts and Graphs [IGCSE ICT 0417]](http://i.ytimg.com/vi/jn3YX3SN2w8/mqdefault.jpg)
![Excel Charts and Graphs [IGCSE ICT 0417]](/img/tr.png)
![Excel IF functions explained: IF, Nested IF, and the new IFS function [IGCSE ICT 0417]](http://i.ytimg.com/vi/X7EX9IjkuFM/mqdefault.jpg)
![Excel References, Relative, Absolute and Mixed references explained [IGCSE ICT 0417]](http://i.ytimg.com/vi/qgankq3WqAE/mqdefault.jpg)
![PowerPoint complete guide, [Cambridge IGCSE ICT 0417]](/img/n.gif)
incredibly useful, binged the whole series, thank you !!🙌🏽
Im glad you found them useful. Wow, binged rhe whole series! You must be taking the exam in April, good luck with that. Let us know how you do.
the explanation is amazingg really understood it hope it helps me in my exam tmmrw thank youuu :)
I am glad it helped. Let us know how you do in the exam
incredibly useful binged the whole series, the crdit goes to you
I am glad you found the tutorials useful. Wow! Binged the whole series! My vouce must be ringing in your head. Thanks for the comment.
@@paphitisn yeah I have an exam tomorrow
@@daniyalkhalid3615 Good luck. Make sure to come back and let us know how i went.
Dude u helped in alot
I am glad to hear that. Thanks for the feedback. Did you sit the ICT exam? How did it go?
Hahah tysm for the series but what is that green whitenflickering light at row 8, keeps distracting me lol
that is from the recording software that indicates the window is being recorded. Looks like instead of recording window it recorded the selected area which was nearly the whole window and as a result the outline of the selection was part of the recording. Yes if you pay attention to it, it can drive you nuts. cover it up to save your sanity :)
@@paphitisn haha ty for the videos
sir is this still in syllabus?I couldnt find this in the book
Yes it is.
Here is the link to the syllabus 2023-2025. Look at section 15.1
chrome-aj/www.cambridgeinternational.org/Images/595352-2023-2025-syllabus.pdf
@@paphitisn oh ok thanks alot your videos are really helpful
hi, in my recent paper i used count ifs in one of the formulas but my teacher told me it isnt part of the igcse syllabus. could you please let me know if i will be given marks for that or not
the syllabus states counting and countifs is a counting function. The syllabus does not state individually the counting functions like count, counta or even countif but they are identified in the mark scheme so you are good.
@@paphitisn thank you so much! I feel so relieved 🤠
Sir please can you explain what the and statement does please
The AND statement allows you to check multiple criteria. It will only return true if all the criteria is met. For example:
If you want to buy a car, you go to the dealer and you give your criteria. Let say you only give one criteria which is:
price is more than 5000 (>5000)
then ,the dealer will show you all the cars which cost more than 5000
if you want to give 2 criteria because some of the cars he is showing you are very expensive and you don't want to spend more than 10000, then you want this to be ANDED (AND) together, for example:
price is >5000 AND 5000, price
@@paphitisn thank you very much sir