Test Papers / Previous Question Papers of IGNOU CS612 PC Software Skills December 2005

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination

December, 2005

CS612 : PC SOFTWARE SKILLS

Time: 2 hours
Maximum Marks: 75

1. (a) Three married couples are to cross a river in a boat which can hold only two persons. one of whom must row the boat. Each of the three husbands is a jealous man who will not allow his wife to be left in the company of other men, unless he is also present. Show how the jealous husbands and their wives can accomplish the trip by labelling all the states on the left and right banks of the river. (8)

(b) What are Macros ? Explain two difterences between Macros and Templates. (5)

(c) What is "Alignment" ? Explain the four alignment options which can be used for document alignment. (7)

(d) What is a URL in Internet ? Explain the fields of a URL through an example. (5)

(e) What is a Domain Name System (DNS) ? What are the bases of classifications of DNS ? Explain with two examples each. (5)

2. (a) What are dialog boxes ? Explain the steps to create and run a dialog box. (5)

(b) What is a protocol ? Explain any two commonly used Internet protocols. (5)

(c) What is Format Painter ? Give the steps involved in applying Format Painter. (5)

3. (a) What is a Search Engine in Internet ? List any six search engines available on Internet. (5)

(c) Write three differences between a work book and a work sheet. (3)

(d) 'Databases can be created in MS-Excel.' True or False ? Give reasons for your answer. (2)

4. (a) Explain the meaning and purpose of the following : (6)
(i) AutoFormat
(ii) Pivot Table
(iii) Custom Control

(b) Give the steps involved in applying advanced filters in a work sheet. (4)

(c) What are the uses of charis in Excel ? What is a Chart Wizard ? Explain two different types of charts. (5)

5. (a) Explain the steps involved in displaying, editing and deleting a Scenario Manager. (6)

(b) What is e-mail ? Explain three common points between e-mail and postal mail services. (4)

(c) Prove that the sum of the squares of the first n integers is (2n)(2n+1)(2n+2)/24. (3)

(d) Prove that the sum of two odd numbers is odd. (2)