M.B.A. DEGREE EXAMINATION, NOVEMBER 2017
Airline and Airport Management
COMPUTER APPLICATION IN BUSINESS
(Upto 2015 Batch)
Time 3 Hours Maximum 75 Marks
Answer TWO question choosen by the examiner through LOT
system. Each question carries equal marks.
MS-Word
1. Create a document and to insert picture in right side and
related information in left side using page layout option
in MS-Word.
2. Create a list of five best friends. Create a thank you
letter. Use mail merge feature of MS-Word to create a
Thank you letter for each of your friends from the above
two files.
3. Create a class time table using table option in MS-Word.
MS-Excel
4. Generate a salary statement of an employee.
5. A company records the details of total sales sector wise
and month wise in the following format
January February March April
Sector 1
Sector 2
Sector 3

Sub. Code
28
CP-8380
2
Wk 10
Enter the data in a worksheet and save it.
Using appropriate formula, calculate the total sales
in each sector
Create a pie chart to show sales in Jan in all
sectors.
6. Draw graphs to illustrate the class performance.
MS-Power point
7. Create a presentation on any topic with heading of topic
using three slides. Give any suitable transition on every
slide.
8. Design slides for the head lines news of a popular TV
channel.
TALLY
9. Prepare a cash book with discount column of Shyam from
the following transactions. Enter the following in Shyam
cash book and show the balance.
2016
Mar 1 Balance of cash in hand Rs. 25,000
Mar 3 Rent paid Rs. 2,000
Mar 5 Purchase goods for cash Rs. 10,000
Mar 10 Stationery purchased for Rs. 2,500
Mar 12 Sold goods for cash Rs. 8,000
Mar 15 Cash received from Ram Rs. 980
and discount allowed Rs. 20
Mar 18 Cash paid to Shyam Rs.950 and
discount received Rs. 50
Mar 25 Wages paid Rs. 2,000
CP-8380
3
Wk 10
10. Pass the journal entries of M/S Ram Traders post them to
the ledger from the following transactions
Date Transactions Rs.
2016
April 1 Commenced business with cash 1,50,000
3 Purchased furniture 25,000
5 Goods purchased 30,000
15 Cash sales 40,000
———————