Get premium membership and access revision papers, questions with answers as well as video lessons.

Computer Studies Question Paper

Computer Studies

Course:Public Health

Institution: Jomo Kenyatta University Of Agriculture And Technology question papers

Exam Year:2013

Spreadsheets Exercise

The following tourists were on holiday in Kenya and during their stay they enjoyed different services in different hotels as shown:
? Cathie Timpson stays at Casablanca for 5 days and enjoys 2 Massage sessions at 1,400/- per session.
? Sue Carlisle stays at Hilton Hotel for 10 days and enjoys 6 facials worth 2,000/- per session
? Amina Abdul stays at Karen Blixen for 22 days and enjoys 10 Gym classes at 2,500 per class.
? Josh Weru stays at Ole Sereni for 6 days and enjoys 1 golf class at 6,000/- per class.
? Henry White stays at Mvuli for 12 days and enjoys 3 swimming sessions at 1,500/- per session.
? Charlie Long stays at Karen Country Club for 2 days and does not indulge in any service.
? Priscilla Saunders stays at West Royale for 14 days and takes 7 Internet sessions at 1,000/- per session.
? Jane Law stays at House of Waine for 6 days and takes 2 Yoga classes at 3,000/- per class.

The following are day rates charged at the different hotels:
Casablanca 3,200/-
Hilton Hotel 4,000/-
Karen Blixen 2,500/-
Ole Sereni 7,000/-
Mvuli 5,200/-
Karen Country Club 6,500/-
West Royale 9,750/-
House of Waine 4,000/-

*Kindly note that a 20% discount is allocated to guests whose final bill is worth more than 50,000/-

Create an Excel spreadsheet to capture the following:
1) Names of the Tourists visiting.
2) Day Rates and days spent in each hotel by each tourist.
3) Total amount of Day Rates (Insert proper formulae for this)
4) Types of Services incurred by each tourist in each hotel
5) Rates at which each Service is charged at different hotels
6) Total Amount of Services taken by each tourist (Insert proper formulae for this)
7) Total Amount of Services and Day Rates (Insert proper formulae for this)
8) Discounted Amount applied to relevant tourists
9) Overall Amount charged
10) Sort the Tourist names in Alphabetical order.
11) A Pie Chart reflecting on the Final Total Bill of each tourist

Computer Studies Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams