Term-End Examination
June, 2OO7
CS-612: PC SOFTWARE SKILLS
Time : 2 hours Maximum Marks : 60
Note :
(i) Question number 1 is compulsory.
(ii) Answer any three questions from the rest.
l. (a) Given 13 cricket balls, one of them heavier than the rest, how can you determine it, in not more than 3 weighings, using decision tree ? (7)
(b) Explain the concept of filtering a database in MS-Excel using Autofilters and using Advanced filters. (7)
(c) What is the difference between 'lnternet' and Network' ? What is the role of TCP /IP in Internet ? Also, list the hardware components used in the Internet.(6)
(d) What is Chart Wizard in MS-Excel ? Write the step-by-step method to create charts using Chart Wizard. What are the components of Chart Wizard ? (7)
(e) What is a template ? Explain with an example. (3)
2. (a) Prove that for any prime p > 5, p(power 2) + 2 is composite. (5)
(b) What is a Function Wizard in Excel ? What are its uses ? (2)
(c) What is the use of GOAL SEEK ? Explain with an example (3)
3. (a) Prove that for every integer n > 2 (7)
(n!)(power 2) > n(power n)
(b) What is meant by URL? What are its components ? (3)
4. (a) Compare the different types of lnternet connectivity mechanisms. (6)
(b) Explain how the access of workbook in Excel can be restricted from other users. (4)
5. (a) Write short notes on any two of the following : (4)
(i) HTTP '
(ii) Telnet
(iii) FTP
(iv) Domain Name System
(b) Explain the following functions giving example for
each : (6)
(i) EXACT()
(ii) IF()
(iii) MOD()