APPLICATIONS
Term-End Examination
December, 2006
CS-612: PC SOFTWARE SKILLS
Time : 2 hours Maximum Marks : 60
------------------------------------------------------------------
Note : Question number 1 is compulsory. Answer any
three questions from the rest.
------------------------------------------------------------------
1 (a) A father has two sons. Four years ago, the father was three times as old as his eldest son and four years hence, the eldest son will be twice as old as the younger son. If the younger son is now 8 years
old, find the father's present age. (7)
(b) Summarize the working of any two of the following :
(i) E-mail
(ii) Telnet
(iii) Search Engine
(c) Explain the features of the following with example : (6)
(i) Goal Seek
(ii) Solver
(d) Suppose m & n are integers, such that n(power 2) + 1 -.2m, Prove that m is the sum of squares of two integers.
(e) What is domain name ? Name any four top domain names. (3)
(f) Explain, with example, how charts in Excel are used (4)
in analysis.
2. (a) What do you understand by the term Internet Protocol ? Explain HTTP protocol and what it is used for. (5)
(b) If three persons (equally able) can jointly finish /complete three jobs in three days, then 100 persons (of the same ability) can jointly do 100 such jobs in how many days? (5)
3. (a) Explain the following functions giving exarmples for (6)
each :
(i) LEN()
(ii) FLOOR()
(iii) CEILING()
(b) Comment on the statement "Every graph is not an Euler's graph". Using a diagram, illustrate different parameters which decide that a graph can have an Eulerian walk or not (4)
4. (a) What do you understand by the term Custom Controls ? List the (5)sequence of steps involved in creating custom controls.
(b) How does we use FTP ? Discuss any three FTP commands. (5)
5 . Write short notes on any four of the following : (10)
(a) Autofit
(b) E-commerce
(c) Auto templates
(d) DNS
(e) Pivot tables