Bangalore University 2006 B.Com Computer Science Computer in Business - II - Question Paper

II Year B.Com. Examination, May / June 2006
(1997-98 Scheme)
COMPUTER SCIENCE
Computer in Business - II

Time : three Hours Max. Marks : 70

Instructions : ans all the parts.

PART - A

ans any 8 ques.. every ques. carries 2 marks.
8x2=16)

1. What is word processing ?

2. What is wizard ?

3. Write any 2 methods of deleting a text in MS-Word.

4. Write any 2 applications of Excel.

5. What do you mean by customizing the spread sheet ?

6. Write any 4 relational operator can be used in Excel.

7. elaborate the datatypes supported by Excel package ?

8. How do you open and close a database file ?

9. What is Macro substitution in DBMS ?

10. Write the difference ranging from SORT and INDEX in DBMS.

PART - B

ans any 6 ques.. every ques. carries 4 marks. (6x4=24)

1. Compare Manual Accounting with that of Computerised Software Systems.

2. Write the steps to be followed in obtain and change choice of MS-WORD.

3. How can a user set margins and tabs in MS-WORD ?

4. What is the difference ranging from cut-paste and copy-paste operations in MS-Word.

5. Write the difference ranging from DO and DOCASE in DBMS.

6. Briefly discuss the concept "Multiple database files" in DBMS applications.

7. discuss IF function in EXCEL with an example.

8. With syntax discuss a lowest 4 financial functions used in Excel.

PART - C

ans any 3 ques.. every ques. carries 10 marks. (3x10=30)

1. discuss the steps to perform mail merge with example.

2. discuss the procedure to create a Bar Chart in detail with the relevant steps.

3. discuss e functions and procedures ? elaborate the advantages of using them ?

4. Create a learner database with five fields, insert five records, display them. All 1 more field to the data base.

5. discuss features and advantages of DBMS.

------------------------------

Earning:   Approval pending.