Scribd
Upload
31 views2 pages

Tourist Details Tourist Name Age Residential City # of Passengers Booking ID Upgrade?

The document contains details of 10 tourists including their name, age, residential city, number of passengers, and booking ID. It also contains 5 destinations with IDs from D101 to D105. The second table contains booking details of 10 tourists including booking ID, destination ID, travel class, and package.

Uploaded by

Dayne Depenha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
31 views2 pages

Tourist Details Tourist Name Age Residential City # of Passengers Booking ID Upgrade?

The document contains details of 10 tourists including their name, age, residential city, number of passengers, and booking ID. It also contains 5 destinations with IDs from D101 to D105. The second table contains booking details of 10 tourists including booking ID, destination ID, travel class, and package.

Uploaded by

Dayne Depenha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Tourist Details

Tourist Name Age Residential City # of Passengers Booking ID Upgrade?


Rohan Jain 64 Mumbai 5 B101
Akshay Shetty 22 Mumbai 3 B102
Nikita Bhansali 43 Mumbai 6 B103
Manuel Barreto 27 Kolkata 5 B104
Elvis Dsilva 37 Mumbai 5 B105
Dhwani Sanghvi 61 Hyderabad 8 B106
Dyuti Shukla 44 Pune 12 B107
Abishek Khatri 33 Pune 2 B108
Raveena Pandya 21 Nashik 5 B109
Jamsheer Ghadially 21 Hyderabad 8 B110

Destination ID D101 D102 D103 D104 D105


Destination Shanghai Tokyo Singapore Delhi Bali

Assignment
Answer all these questions by designing formulas using Lookup and Reference or Logical Functions ONLY
Questions ANSWER (Type Formula that will give the ans
1 What is Dhwani Sanghvi's Travel Class?
2 To which city is Akshay Shetty Travelling?
How many rows and columns are there in Table
3 "Tourist Details"
Fill in the upgrade column such that it reflects
"TRUE" if the age of the tourist is above 40, he
resides in Mumbai, and has more than 3 passengers
4 traveliing and FALSE otherwise

Fill in the Package column such that it reflect "Gold"


if the travel class is business and "NORMAL"
5 otherwise
Booking Details
Booking ID Destination ID Travel Class Package
B104 D105 Economic
B106 D101 Economic
B101 D108 Business
B103 D105 Business
B105 D107 Business
B107 D103 Economic
B102 D102 Business
B110 D101 Economic
B108 D107 Business
B109 D105 Economic

D106 D107 D108


Singapore Dubai Mauritius

r Logical Functions ONLY


Type Formula that will give the answer)

You might also like