DISTANCE EDUCATION
B.Com. DEGREE EXAMINATION, DECEMBER 2017.
Lab I MS. OFFICE
(2005 onwards)
Time Three hours Maximum 100 marks
1. Each question carry 100 marks. Answer ALL
the subdivisions.
2. Examiner has to give ONE question to each
candidate by lot system.
Problem 1
Using the MS-WORD, type the covering letter to
your managing director for purchasing raw
materials. Format the letter Page by the following
formatting features
• Right Align each line
• Choose appropriate Font Size in each line.
• Choose Font type (Times New Roman) where
needed for a letter display
• Apply Bold in the letter caption.
• Use colour options as your feel appropriate.
• Apply Spell check to correct spelling mistakes
(if any)
Sub. Code
15
DE-9808
2
sp4
Problem
Using the MS-WORD prepare the TIME TABLE of
your class and perform the following
Apply appropriate size of border of table
Choose appropriate Font Size in each line.
Choose Font type (Times New Roman) where
needed for a letter display
Apply Bold for table Header.
Use colour options as your feel appropriate.
MS-EXCEL
Problem
Create the following EMPLOYEE PAYROLL worksheet
in Excel
A B C D E F G H I J
1 Sno Empno Name Age BASIC DA HRA PF GROSS NET
2 1
3 2
4 3
5 4
6 5
TOTAL
AVERAGE
Cut here
DE-9808
3
sp4
Calculate the TOTAL of column BASIC, DA, HRA,
PF, GROSS AND NET.
Calculate the AVERAGE of each column BASIC,
DA, HRA,PF, GROSS AND NET.
Format AVERAGE with 2 decimals.
Sort this list by Employee NO.
Sort first by NAME then AGE.
Find the NET AND GROSS PAY of each employee
Problem 2
Create the following worksheet in Excel
B C E F G H
REGNO NAME MATHS ENGLISH SCIENCE TOTAL
123 XXXX 65 60 90
124 YYYYY 45 63 49
125 ZZZZ 50 58 74
126 AAAA 72 38 82
127 BBBBB 48 40 81
Calculate the TOTAL column.
Fill the candidates whose REGNO>=124
Filter the candidate whose NAME
Filter the candidate whose ENGLISH >60
Cut here
DE-9808
4
sp4
MS-ACCESS
Problem 1
Create EMPLOYEE ADDRESS table with following
Fields
FIELD NAME DATA TYPE
ENAME TEXT
AGE NUMBER
SEX TEXT
STREET TEXT
CITY TEXT
PIN NUMBER
1.1 Add 5 Records.
Enter the following RECORDS:
ENAME AGE SEX STREET CITY PIN
ALAGAPPAN 25 M ANNA
STREET
KARIAKUDI 630003
BHARATHI 18 F SOUTH
STREET
MADURAI 625001
KUMAR 21 M 1ST STREET CHENNAI 600006
KAMARAJAN 38 M WEST
STREET
KARIAKUDI 630001
TIRUVALLUVAR 17 M RAJA STREET KARAIKUDI 630002
DE-9808
5
sp4
1.2 Display the fields NAME, STREET alone on the
screen.
1.3 Display the records for AGE 20
1.4 Display the records for AGE 20 AND CITY
'KARAIKUDI'
1,5 SORT the table in the ascending order of NAME.
Problem 2
Create STUDENT table with the following Fields:
FIELD NAME DATA TYPE
REGNO NUMBER
NAME TEXT
MARK1 NUMBER
MARK2 NUMBER
TOTAL NUMBER
PERCENTAGE NUMBER
2.1 Add 5 Records using FORMS.
Enter the following RECORDS
REGNO NAME MARK1 MARK2 TOTAL PERCENTAGE
2000101 SUNDAR 45 35 76
2000102 KUMAR 55 24 79
2000103 RAJAN 33 35 65
2000104 SUBHA 22 21 84
2000105 NATHAN 21 18 91
DE-9808
6
sp4
2.2 Calculate the total for each students.
2.3 Display the records for NAME 'NATHAN'
2.4 Display the records for NAME 'NATHAN' and
PERCENTAGE> 80
2.5 SORT the table in the descending order of
PERCENTAGE.