Official Thread for AICT Doubts !

[The Golden Girl =D]

This is the "Official Thread for AICT Doubts" where you can post ALL your doubts from which ever board you're taking

Make sure that you mention the following when posting your doubt :

1. The board you're taking.
2. The Year and the session e.g. June 2011.
3. The Paper e.g. Unit 1 for Edexcel.
4. The the number of Question you have doubt in.
5. If you can upload the paper in the "Additional Options" it would make it easier for others to answer.


Thank you.
SF Administration Team

[Dibss]

CIE May June 09 P2 the practical
q 21 and 24
I used HLOOKUP
but then when I drag down to duplicate, the array changes as well :SSS
I've attached the excel sheet and the question paper.
Any help would be appreciated!

[Malak]

CIE May June 09 P2 the practical
q 21 and 24
I used HLOOKUP
but then when I drag down to duplicate, the array changes as well :SSS
I've attached the excel sheet and the question paper.
Any help would be appreciated!

I couldn't open your file for some reason  
Anyway, here is my file attached. Check your formula with mine, i guess you didn't lock the array. I have used HLOOKUP and it works.

[Dibss]

Thank you +rep
Your formula was:
=HLOOKUP(LEFT(B5,1),$B$1:$F$2,2,FALSE)
Mine was:
=HLOOKUP(MID(B5,1,1),B1:F2,2,FALSE)
So you're right the problem was with my array - how did you lock it? Did the $ sign come automatically? I selected the mini table cells I wanted to use, i'm guessing that's the wrong way?

[Dibss]

One more question.
Do you know how to format cells into pounds for currency? All the PCs I've come across only seem to have the $ and euro option for currency fields (which is especially a problem for the access practicals :/).

[NotAbod]

Press f4 to lock the array

Edit: currency depends on your language sittings. Yours is "english US" so you will have $ and euro
Change it to english UK

[Malak]

Abod has already answered the Qs but i think it doesnt matter what your computer settings are as you can always choose a different currency in access/excel etc.

I miss doing these practicals *sigh*
Excuse me for being random 

[Dibss]

+rep Abod

Thank you both (:

[Malak]

+rep Abod

Thank you both (: haha we've been experimenting the whole term with these practicals with a shady teacher without managing to complete even one and the exam is next month so excuse me for wanting to get it over with

Lol, my teacher was Awesome. He made solving the practicals so much fun.

Good luck by the way!

[Mike Benn]

Hey Guys, i got a question from AS APplied ICT ( CIE ) Brian Sargent Book,page 175, how to re-size the image, em kinda screwed, and any one from kuwait, cz i badly need a tution

[NotAbod]

Hey Guys, i got a question from AS APplied ICT ( CIE ) Brian Sargent Book,page 175, how to re-size the image, em kinda screwed, and any one from kuwait, cz i badly need a tution

for resizing any image,  use a software like photoshop or microsoft office picture manager.
i have the book, but uh, just the first 4 chapters 
By the way I'm from kuwait

[Mike Benn]

for resizing any image,  use a software like photoshop or microsoft office picture manager.
i have the book, but uh, just the first 4 chapters 
By the way I'm from kuwait

OH Thanks alot, it's MS WORD , that's y asked, By the way em giving ICT this October that's y , tensed, and abov all no teacher, u know anyone, plz help

[NotAbod]

Welcome
maybe our ICT teacher can help, I'll ask him tomorrow.

[Mike Benn]

Welcome
maybe our ICT teacher can help, I'll ask him tomorrow.

Yea, Plz do that. I would be Thankful , and my contact no. if u got a positive reply *don't post mobile numbers*... + em ready to give as much fee as your teacher asks, Plz just help me out..!!

[NotAbod]

okay
will text you tomorrow.
read my pm