Posted Date: 17 Oct 2008      Posted By:: pushpam    Member Level: Gold  Points: 5 (Rs. 1)

# 2007 Maharaja Krishnakumarsinji Bhavnagar University Commerce B.Com Lab I — MS-OFFICE Question paper

 Course: B.Com University/board: Maharaja Krishnakumarsinji Bhavnagar University

Lab I — MS-OFFICE

Time : Three hours Maximum : 100 marks
Answer any TWO question choosing one from MS-Word and another ONE from either MS-EXCEL or MS-ACCESS.
Each question carries 50 marks.
Candidate has to choose the questions by lot system.
MS-WORD
1. Create a new document file and types the following equations :
(a)
(b)
(c)
(d) .

2. Type the student LEAVE LETTER to be posted to HEAD OF THE DEPARTMENT.
Format the leave letter as it is and apply the suitable Font Type and Font Size.
3. Create the table with contents :
Sl. No. Article name No. of items Price
1
2
3
4
5

MS-EXCEL
4. Sorting Data :
Create the following worksheet in Excel.
ROLLNO. NAME TAMIL ENGLISH MATHS SCIENCE TOTAL AVERAGE
001
002
003
004
005
(a) Fill the TOTAL column.
(b) Fill the AVERAGE column.
(c) Replace the RESULT with PASS for
AVERAGE > = 50 ELSE FAIL.

5. Try with Bar Graph for the following data :
AMOUNT IN CRORES
YEAR SALES EXPENSE
1997 25 10
1998 30 15
1999 35 20
2000 43 25
2001 50 30
2002 55 35
2003 60 40
2004 65 45
6. Filtering Data :
Create the following worksheet in Excel.
ROLLNO. NAME COMPUTER MATHS SCIENCE TOTAL
220 GEETA 85 100 80
221 SUDHA 90 98 85
222 RAMA 95 95 90
223 BANU 82 83 87
224 LATHA 96 80 75
(a) Fill the TOTAL column.
(b) Filter the candidate whose ROLLNO > 221
(c) Filter the candidate whose MATHS > 90.

7. Calculate HRA, DA, GPF, LIC, Gross Salary, Deductions, Net Salary from given data in a worksheet :
Eno Ename BASIC HRA DA GPF LIC GS DD NS
Where HRA is 15% of BASIC
DA is 13% of BASIC
GPF is 9% of BASIC
LIC is 4% of BASIC
GS = BASIC + HRA + DA
DD = GPF + LIC
NS = GS – DD

MS–ACCESS
8. Create student table with the following fields and add minimum 5 records.
Field Name Data type
REG NO NUMBER
NAME TEXT
AGE NUMBER
SEX TEXT
DEGREE TEXT
PERCENTAGE NUMBER
9. Create mark list of a student in the following format using reports.
MARK LIST
ROLL NO : 320189 Sname : MURUGAN
TAMIL --------
ENGLISH --------
MATHS --------
SCIENCE --------
TOTAL
AVERAGE --------

10. Create Employee salary table and give 5 records. The salary field cannot accept > 40,000 and display the records for salary > 30,000.
Field Name Data type
S. NO. NUMBER
EMPLOYEE NAME TEXT
DESIGNATION TEXT
DEPARTMENT TEXT
SALARY NUMBER

### Related Question Papers:

• PRINCIPLES OF MANAGEMENT

• BASIC FINANCIAL ACCOUNTING

• ### Categories

Submit Previous Years University Question Papers and make money from adsense revenue sharing program

Are you preparing for a university examination? Download model question papers and practise before you write the exam.

 Join Group

Top Contributors
TodayLast 7 Daysmore...