Computer in Business - II Question Paper - 2006

II Semester B.com Examination, May/June 2006
(Semester Scheme)
COMPUTER SCIENCE
Computer in Business - II

Time: 3 Hours                                                                 Max. Marks : 70

Instruction:  1) Answers Should be written completely only in English. 
                        2) Answer all the Sections.

SECTION - A

Answer any 8 sub-questions. Each sub-question carries 2 marks.           (8x2=16)

1. What is word processing ?
2. What is wizard ?
3. Write any two methods of deleting a text in MS-Word.
4. Write any two applications of Excel.
5. What do you mean by customizing the spread sheet ?
6. Write any four relational operator can be used in Excel.
7. What are 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 between SORT and INDEX in DBMS.

SECTION - B

Answer any 6 of the following questions. Each question carries 4 marks.   (6x4=24)

1. Compare Manual Accounting with that of Computerised Software Systems.
2. Write the steps to be followed in FIND and REPLACE option of MS-WORD.
3. How can a user set margins and tabs in MS-WORD ?
4. What is the difference between cut-paste and copy-paste operations in MS-Word.
5. Write the difference between DO and DOCASE in DBMS.
6. Briefly explain the concept "Multiple database files" in DBMS applications.
7. Explain IF function in EXCEL with an example.
8. With syntax explain a least four financial functions used in Excel.

SECTION - C

Answer any 3 of the following questions. Each question carries 10 marks.     (3x10=30)

1. Explain the steps to perform mail merge with example.
2. Explain the procedure to create a Bar Chart in detail with the relevant steps.
3. Explain e functions and procedures ? What are the advantages of using them ?
4. Create a student database with 5 fields, insert 5 records, display them. All one more field to the data base.
5. Explain features and advantages of DBMS.