CS 612 PC Software Skills

Note: Question number 1 is compulsory. Answer any three questions from the rest.

Q.1
(a) John is an honest milkman supplying milk in two houses. One day the two ladies asked for two litres milk each One lady was carrying a five litre pan and the other a four litre pan. John had only two forty-five cans, each full of milk. How would be measure exactly two litres of milk for each lady?

(b) What is an Address Book, and why is it required? How are new addresses added to the Address Book?

(c) What are Cell References? Explain three ways of giving cell references, with examples of each implemented and explained through formula.

(d) Differentiate between spitting of windows and freezing of windowpanes.

(e) State and prove Jung’s theorem.

(f) How can names be given to a range of cells? What are the rules for defining range names? List two valid and two invalid range names.

Q.2 a) What is a Domain name System (DNS)? Explain the username, host, domain and subdomain in the context of an Internet Address.

(b) Differentiate between a Worksheet and Workbook. Give three ways to restrict access to your workbook.

Q.3
(a) What is the utility of viewing a worksheet in multiple windows? Explain four ways of arranging the windows on the screen.

(b) Explain two ways to share information with people having common interest, on the Internet.

Q.4
(a) How can data in a database be filtered? Explain Autofiles and Advanced filters.

(b) What is a template? Also explain why it is called a Special Workbook.

(c) State Goldbach’s conjecture. Why is it called a conjecture, and not a theorem?