• 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)

AICT 9713, Computing 9691 Problems

Messages
2,222
Reaction score
6,346
Points
523
yeah rit , i eally get bored to read that stuff, exam mein chalo i mit read it , par at home , never!! :sleep::)

what u MIGHT read it...!! u have to read it...!! :p remember what u did in English ka skl exam...!!?? therefore read the question ppr properly :)
 
Messages
2
Reaction score
1
Points
3
Create a search for a customer enquiry. When run, this will prompt for the Region to be
visited and the number of passengers.
The search should display the results for all boats in the chosen Region where the
number of Guests is greater than or equal to the number of passengers entered.
Include the Region, BoatModel, HireP/W, Company, and the other fields in the
BoatSpecs table.
Save this search as Region and Guests
Include in your evidence document a screen shot showing all the fields and the search
criteria.



This is from summer 2009 p4 number 5.. how to do it. please help..
 
Messages
2,222
Reaction score
6,346
Points
523
S10 question 3
in CELL A4
=IF(A2<>"",VLOOKUP(A2,lookup table array,3,FALSE),"")

in CELL C2
=IF($A$2<>"",VLOOKUP($A$2,lookup table array,11,FALSE),"")

here u have to change d number after d table array...for eg: it is 11 here coz IDACOPT5 is in d 11th column
so for the next cell u will put 6 n NOT 11 coz it's IDBC04 so it will b (in cell C3)
=IF($A$2<>"",VLOOKUP($A$2,lookup table array,6,FALSE),"")

in CELL D2
=IF(C2="y",VLOOKUP(B2,lookup table array,3,FALSE),"")

AAnsarii plz check if it is right coz i did it n got d correct answer...

in column C, d heading specifies Y/N. so u just add an if:
=IF($A$2<>"",IF(VLOOKUP($A$2,lookup table array,11)<>"","Y","N"),"")

ie, if its nt empty, (so it'll hv "y" in it) u put Y, n if it is empty, put N.

AngelicBeauty fille spéciale acas shaikh
 
Top