APPLICATIONS
Term-End Examination
December, 2OO7
CS-612 : PC SOFTWARE SKILLS
Time : 2 hours Maximum Marks : 60
Note :
(i) Question number 1 is compulsory.
(ii) Answer sny three questions from the rest.
1. (a) Prove that the product of four consecutive natural number cannot be the square of an integer. (8)
(b) With the help of an example, explain how to enter a formula, do some calculations and also mention to edit the formula in MS-EXCEL. (7)
(c) Summarize the basic features of any search engine. Also, list the basic options that would be available on them. (7)
(d) What is the significance of Domain Name System ?List any three geographic and non-geographic domain names. (8)
2 (a) With respect to MS-Excel,What are internal and external databases? List any two external databases. Also, explain any one way to create a database in EXCEL. (5)
(b) With the help of an example, explain the application of a decision tree. Also draw the decision tree for the example problem. (5)
example problem.
3. (a) Write the basic functionality of the following in
MS-EXCEL : (6)
(i) Format Painter
(ii) Function
(iii) Chart Wizard
(b) Write the process of sending an attachment (either a text file or image) through an email. (4)
4. (a) What is the remainder left after dividing
1! + 2! + 3! + + 100! by 7 ? (5)
(b) List any five important features of any GUI browser. (5)
5. Write short notes on any four of the following : (10)
(a) Decanting Problems
(b) Minimum spanning circles
(c) FTP
(d) Gopher
(e) Doughnut and Radar charts