APPLICATIONS
Term-End Examination
June, 2006
CS-612 : PC SOFTWARE SKILLS
Time : 2 hours Maximum Marks 60
--------------------------------------------------------------------
Note : Question no. 1 is compulsory. Answer any three
questions lrom the rest.
--------------------------------------------------------------------
l. (a) John is an honest milkman supplying milk in two houses. One day the two ladies asked for two litres of milk each. One lady was carrying a five litre pan and the other a four litre pan. John had only two
forty-litre cans, each full of milk. How would he measure exactly two litres of milk for each lady ? (9)
(b) What is an Address Book, and why is it required ? How are new addresses added to the Address Book ? (4)
(c) What are Cell References ? Explain three ways of giving cell (5) references, with examples of each implemented and explained through formulae.
(d) Differentiate between splitting of windows and freezing of window panes. (2)
(e) State and prove Jung's theorem. (5)
(f) How can names be given to a range of cells ? What (5)
are the rules for defining range names ? List two valid
and two invalid range names
2. (a) What is a Domain Name System (DNS) ? Explain the terms username, host, domain and subdomain in the context of an Internet Address. (5)
(b) Differentiate between a Worksheet and a Workbook.Give three ways to restrict access to your workbook. (5)
3. (a) What is the utility of viewing a workheet in multiple windows ? Explain four ways of arranging the windows on the screen. (5)
(b) Explain two ways to share information with people (5)
having common interest, on the Intenet.
4. (a) How can data in a database be filtered ? Explain Autofilters and Advanced filters. (5)
(b) What is a template ? Also explain why it is called a Special Workbook. (2)
(c) State Goldbach's conjecture. Why is it called a conjecfure, and not a theorem ? (3)
5. (a) Explain the following terms, with examples : (6 )
(i) Mailing Lists and Mail Reflectors
(iil Telnet
(iii) Autotemplates
(b) Show that for all positive integers n, 2(power 2n- 1) + 1 (4)
divisible by 3.