IGCSE ICT Paper 3 Spreadsheet May June 2021 Variant 31 (0417) | Microsoft Excel
ฝัง
- เผยแพร่เมื่อ 7 พ.ย. 2024
- #igcseict #gcseict #dataanalysis #dataanalyst #igcseictdataanalysis #igcse #spreadsheet #spreadsheethelp #msexcel #excel #exceltips #exceltutorial #googlesheets
0417/31/m/j/21
hey! Im a bit confused why when you lookup you do the column number + a number could you please explain?
It’s because the column index have to be a number and it needs to increment
@@ajirotech Okay, I get why it has to be a number but why with some lookups it doesn't increment??? How do I know when to increment it and when to not?
Why did u use column no A10 and why not the column no of other table how do we come to know when to use when
When they provide you a hint that’s your column index
@@ajirotech thank you
@ritukhanna3223 you’re welcome don’t forget to share this TH-cam channel to your friends
22:15 , why equal to zero ! we are looking for text rather, shouldn't we use "".
It’s the same thing 😊
WHY DID U DO A10 +1 !??
So that it will increment by 1 so instead of starting from the header it will begin with the records
❤❤ 0:35 mary ann peregrino march 03/27/1978 1:18 and good health for you're family ok 1:44
🤔
❤😊malabon dumsite talisay g 2021 9:08
share this TH-cam channel to your friends
Hi Ajiro!
Question Please, can you use alternative formulae and still get the full marks for that question? Please check my answer for question 18... in row 10
=IF(XLOOKUP(B4,j2131home.csv!$B$2:$H$2,j2131home.csv!$B$3:$H$3)0,XLOOKUP(B4,j2131home.csv!$B$2:$H$2,j2131home.csv!$B$3:$H$3),"")
Yes you can use alternative formulae and you will get the full mark
@@ajirotech You have helped me so much, thank you Ajiro, I have shared your channel with my friends
❤😊 from Philippines pampangga lapidsville sapang maisac mexico pampangga 💜💙💥✔️ 6:05
Do well to share this TH-cam channel to your friends and classmates
Home my sister Lui angel grocery general merchandise ugong Valenzuela city Philippines Valenzuela city 6:50
Okay