Qualification > Miscellaneous

ICT Doubt.

<< < (5/13) > >>

nid404:
This doubt is from the november 2007, paper 2 , step 49wherein you need to export a query as .csv. After this is done u need to open the file in excel and use a lookup function for a cell that contains initials and replace them with their full names. The problem is that the lookup value is the initial in the cell itself. So when I write the formula, it gives an error of circular reference. So how is it supposed to be done??? I've got my paper tomorrow. Please don't say this is not in the paper. I really don't want to know what's there and what's not.  Please tell me how to do this.
Thanks

emi:
sgvaibhav   if u knew how to do the email part plz tell me also ,, i have exam on 17 .

and tanya ,, why does every one use vLookup function instead of lookup ??

can any one please explain why   

saadmannan:
b/c it is recommend by cambridge in all the mark schemes they  use VLOOKUP and not lookup.......this is wat my tacher told me

Today i had my Paper 2 it was the best exam....the invidulator was presented with food and he kept on eating and we were sitting very closer to each other it was kinda easy...our teacher just old us wat is coming 30min before our exam.......
it was cool

sweetsh:
Guys...A website which I really prefer for studying ICT practical or written is www.teach-ict.com 
This website offers you alot..Go have a look I hope you benefit

ughthu:
Hey guys....had ma ppr 2 today..wasnt that bad...juss wanna make sure that in which format our dates were supposed to come in reports..... dd/MM/yyyy or dd/MMM/yyyy

i hope u get the question.....
asin...e.g

01/01/2009 or 01/jan/2009....

Thanks..:)

Navigation

[0] Message Index

[#] Next page

[*] Previous page