Bhavnagar University 2007 B.Com Lab I — MS-OFFICE - Question Paper

Lab I — MS-OFFICE

Time : 3 hours Maximum : 100 marks
ans any 2 ques. choosing 1 from MS-Word and a different 1 from either MS-EXCEL or MS-ACCESS.
every ques. carries 50 marks.
Candidate has to select the ques. by lot system.
MS-WORD
1. Create a new document file and kinds the subsequent equations :
(a)
(b)
(c)
(d) .


2. Type the learner LEAVE LETTER to be posted to HEAD OF THE DEPARTMENT.
Format the leave letter as it is and apply the suitable Font kind 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 subsequent worksheet in Excel.
ROLLNO. NAME TAMIL ENGLISH MATHS SCIENCE TOTAL AVERAGE
001
002
003
004
005
(a) Fill the TOTAL column.
(b) Fill the avg. column.
(c) Replace the outcome with PASS for
AVERAGE > = 50 ELSE FAIL.

5. Try with Bar Graph for the subsequent 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 subsequent 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 provided 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 learner table with the subsequent fields and add minimum five records.
Field Name Data kind
REG NO NUMBER
NAME TEXT
AGE NUMBER
SEX TEXT
DEGREE TEXT
PERCENTAGE NUMBER
9. Create mark list of a learner in the subsequent format using reports.
MARK LIST
ROLL NO : 320189 Sname : MURUGAN
TAMIL --------
ENGLISH --------
MATHS --------
SCIENCE --------
TOTAL
AVERAGE --------


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

Earning:   Approval pending.