4IT0/02 Edexcel IGCSE June 2016 Paper Activity 4 (Spreadsheets)

Walkthrough tutorial of the June 2016 Edexcel Paper. Spreadsheet section.

[gtashorts]

appreciate it sooo much, i had an assingment for 15 mrks, i got 15/15

[duchess]

Hello and good day to you, sir. I want to know how you did that 'less than 3' bedrooms filter because once you have zoomed in, it did not focus on that. Thank you for the video. I hope you do more spreadsheet tasks with tips and all to quickly and smartly solve them. I have difficulty with those accounting-ish questions. Would appreciate it if you could provide compiled formulas that are found common in spreadsheets besides if, sum, average, max, min, vlookup, counta, countif and sumif.
Also sir, would you kindly show how to do sumif with multiple criterias?