DISTANCE EDUCATION
B.Com. DEGREE EXAMINATION, MAY 2016.
LAB I — MS-OFFICE
(2005 onwards)
Time Three hours Maximum 100 marks
Instructions
1. Each question carry 100 marks. Answer ALL the
subdivisions and
2. Examiner has to give ONE Question to each
candidate by lot system.
1. Type a letter in Word to bank manager to issue
cheque book for your savings bank account. Format
the letter appropriately with bold, underline, italic
formatting.
Create an Excel Worksheet containing three subject
marks for 5 students. Find the total marks for each
student. Find the maximum and minimum total.
Create a table in Access to store the following data
for students: REGNO, NAME, Date of Birth, City,
Total Mark in Higher Secondary Examination.
Create a Query for the following:
To show data for students from a particular
city.
To show data of students scored more than
1000 marks.
Sub. Code
15
DE-9162
2
wk11
2. Type your biodata in a table using MS-Word shown
below.
BIO-DATA
NAME RAMANAN K
DATE OF BIRTH 20-01-1991
ADDRESS FOR COMMUNICATION .................
QUALIFICATION .................
Hide the borders to show your biodata without
borders.
Create an Excel Worksheet for electricity bill
calculation with the following data: Service
Number, Consumer Name, Address, Old-Meter-
Reading New-Meter-Reading
Consumed Units and Bill. Find consumed units as
NMR-OMR. Compute bill as per the tariff given
below:
Upto 100 units Rs. 3 per unit
Next 100 units Rs. 4 per unit
For remaining units Rs. 5 per unit
Minimum Bill for the Consumer Rs. per month
Compute bill for each consumer. Find the total
value of Bill Column.
Create a table in Access to store the following data
for players: REGNO, NAME, Date of Birth, City,
GAME1 and GAME2. Create a Query for the
following
To show data for players from a particular
city.
To show data of players playing cricket and
football.
DE-9162
3
wk11
3. Type news in three-column format in MS-Word
insert picture and make the text flow around it.
Create a bar chart in Excel between Student Names
and Marks in three subjects namely Maths, Tamil
and English.
Create Access table to store following employee
data: EMPNO, NAME, DESIGNATION and
SALARY. Create query to do the following
To show employees with OFFICER
designation.
To show employees getting more than 20000
as salary.
4. Draw a flowchart to input and add two numbers
using autoshapes.
Create a column chart between Higher Secondary
Student Names and their Maths, Physics,
Chemistry and total marks.
Create Access table to store employee data:
EMPNO, NAME, Date of Birth and Phone Number.
Create query to do the following:
To show employees Born on a particular date
To show employees having phone numbers
ending with 432.
Cut here
DE-9162
4
wk11
5. Create mail merge for sending college reopening
date intimation letter to all the students whose
addresses are stored in data source.
Create an Excel Worksheet to store student data:
REGNO, NAME MARK1, MARK2, MARK3 and
TOTAL. Fill the TOTAL column with the formula
MARK1 MARK2 MARK3. Do the following:
Sort the data in alphabetical order of NAME
Sort the data in ascending order of MARK1
Sort the data in descending order of TOTAL.