DISTANCE EDUCATION
B.Com. DEGREE EXAMINATION, MAY 2017.
LAB I M.S OFFICE
(2005 onwards)
Time Three hours Maximum 100 marks
MS-WORD
1. Problem 1
Using MS-WORD, type your BIO-DATA. Format the
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 caption.
• Use colour options as your feel appropriate.
• Insert appropriate picture.
2. Problem 2
Using MS-WORD, type the covering letter to your
managing director for applying medical leave. 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
Cut here
DE-9509
Ws 6
2
MS-EXCEL
3. Problem 1 Data analysis using Cross-Tabulation
(Data Tables). Create the following worksheet in Excel
A B C D E F G H
1 Sales Cost Profit
2 150 90 =A2
-B2
3
4 Data Table (What If analysis)
5 Cost Sales
6 125 130 135 140 145
7 100
8 120
9 125
10 160
Fill the TABLE by using DATA TABLE command.
4. Problem
Presentation Graphics
Create the following worksheet in Excel
A B C D E F G H
1 INVENTORY DETAILS
2 Month Purchase Sales
3 Jan 20 9
4 Feb 25 12
5 March 35 38
6 April 42 25
Draw the Graph and mention the appropriate title,
legends-axis title and y-axis title
Exercise
Experiment with other types of graphs.
Include more columns (say Opening stock and
closing stock) with data values and create different
types of graphs.
Include grid lines in your graphs.
Cut here
DE-9509
Ws 6
3
MS-ACCESS
5. Problem 1 Create SALES Table with the following
fields.
FIELD NAME DATA TYPE
NAME TEXT
SEX TEXT
SALECODE NUMBER
SALE AMOUNT NUMBER
COMMISSION NUMBER
add 5 Records using FORMS:
Enter the following RECORDS
NAME SEX SALE
CODE
SALE
AMOUNT
COMMISSION
SUBBU M 101 6000 60
RAM M 102 7000 70
LAKSHMAN F 103 4000 40
MANOJ F 104 8000 80
BHARATHI M 105 3000 30
Display the records for SALE AMOUNT
<5000 AND SEX
Update the records for SEX and SALE
AMOUNT 5000
Display the records for COMMISSION 40
SORT the table in the descending order of SALE
AMOUNT
DE-9509
Ws 6
4
6. Problem 2 Create LIBRARY table with the following
Fields
FIELD NAME DATA TYPE
BOOK NUMBER NUMBER
TITLE TEXT
AUTHOR TEXT
PRICE NUMBER
PUBLISHER TEXT
BRANCH TEXT
Add 5 Records using FORMS.
Enter the following RECORDS.
Book
Number
Title Author Price Publisher Branch
555101 RDBMS C.J.DATE 350 PHI CS
444101 Marketing
Management
SUKHLA 400 IDG Commerce
555102 Office
Automation
LEON 250 ALU CS
555103 Java
Programming
PATRICK 400 BPB CS
555104 Office
Automation
RAJAN 300 PHI CS
Display the records for AUTHOR 'PATRICK'
Display the records for BOOK NUMBER 555101
Display the records for PUBLISHER OR
PUBLISHER AND PRICE BETWEEN 300
AND 500.
SORT the table in the Ascending order of BOOK
NUMBER.