• We need your support!

    We are currently struggling to cover the operational costs of Xtremepapers, as a result we might have to shut this website down. Please donate if we have helped you and help make a difference in other students' lives!
    Click here to Donate Now (View Announcement)

Computers & ICT: Post your doubts here!

Messages
38
Reaction score
21
Points
8
Messages
1,162
Reaction score
6,306
Points
523
Can someone help me with these questions.​
Both are all A2 questions for 9713​
O/N 2008 question 15, i just dont understand what they are asking.​
M/J 2010 question 3, i just dont to how to use the lookup formulae for it. Is there like a way to do like a hlookup inside a vlookup?​


w08, q15
in q13, u printed labels 4 Millside Industrial Centre. like dis, u've 2 mk a set of labels without putting any criteria. save dis doc as Autolabels.
in MillsMenu, mk another menu option hyperlinked 2 open dis labels doc u just created. Save As... provide Evidence... etc.


s10 q3
y do u wanna do h inside vlookup?
in A2, d StudentID will b entered. using dis, all d other data shall b referred 2.
this is simple:
in A4, vlookup d surname.
dis will only b done if something IS entered in A2, or else it'll b blank.
=IF(A2<>"",VLOOKUP(A2,<tbl array>,3,FALSE),"")

C2
if d student requires d txtbk (which is given in BookOrders.csv), "Y" should b displayed, or else "N"
=IF($A$2<>"",IF(VLOOKUP($A$2,'Book orders.csv'!$A$2:$K$21,11)<>"","Y","N"),"")


D2
if d student requires d bk, must lookup d cost of d bk, else 0.
=IF(C2="Y",VLOOKUP(B2,'Book list.csv'!$B$2:$D$10,3,FALSE),0)

hope u got it :) all d best
if u still did nt understand, plz tell more specifically where.
May Allah Help us all :)
 
Messages
1,824
Reaction score
949
Points
123
i asked n u asking me?
nth apparantly useful under edit of edit macros.


I don't think commenting will be necessary.. since the macros are not in that much depth.. to write comments in the VB Code.

You type comments with /* */ in the VB Code..

like


print.Document /* Prints the document */ Link me the question where it specifically asks you to comment on the macro.
 
Messages
1,162
Reaction score
6,306
Points
523
I don't think commenting will be necessary.. since the macros are not in that much depth.. to write comments in the VB Code.

You type comments with /* */ in the VB Code..

like


print.Document /* Prints the document */ Link me the question where it specifically asks you to comment on the macro.

w12http://papers.xtremepapers.com/CIE/...unication Technology (9713)/9713_w12_qp_4.pdf
s12http://papers.xtremepapers.com/CIE/Cambridge%20International%20A%20and%20AS%20Level/Applied%20Information%20and%20Communication%20Technology%20(9713)/9713_s12_qp_4.pdf
 
Messages
1,162
Reaction score
6,306
Points
523
I don't think commenting will be necessary.. since the macros are not in that much depth.. to write comments in the VB Code.

You type comments with /* */ in the VB Code..

like


print.Document /* Prints the document */ Link me the question where it specifically asks you to comment on the macro.


error wn entered /*Prints the doc*/:
Capture.JPG
 
Top