December, 2007 CS-612: PC SOFTWARE SKILLS

IGNOU BCA CS-612: PC SOFTWARE SKILLS - DECEMBER 2007 QUESTION PAPER

---

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
December, 2007
CS-612: PC SOFTWARE SKILLS

Time : 2 Hours

Max. Marks : 75

---

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

---

1.(a) Given a 12 liters vessel filled with milk and two empty vessels with capacities of 9
liters and 5 liters. How can you divide the milk into 2 equal portions? Explain and
write the sequence of steps to solve.
(b) If you are given the information that the counterfeit coin is heavier than the others, how
will you pick it in only two weightings?
(c) Explain how the access of workbook in EXCEL can b restricted from other users.
d) Explain the different types of connections to internet.

2. (a) Give the shortcuts to select the following using keyboard in MS-EXCEL:
(i) Current Cell
(ii) Entire Column
(iii) Entire Row
(iv) entire worksheet
(v) Open a new worksheet
(vi) Open an existing worksheet
(vii) Extend selection to End of Data Block
(b) Explain the different types of data that can be entered in worksheet cells.
(c) the 3 ways of referencing the cells in MS-EXCEL worksheet.

3. (a) Explain the following:
(i) WWW
(ii) Telnet
(iii) FTP
(iv) E-Mail
(b) Write the steps to search for a specific information on the internet using a search
engine. List any 10 search engines.

4. (a) Prove that there is atleast one prime between K2 and (K+1)2 for all integers K
satisfying 1£K£20.
(b) What is the remainder left after dividing 1! + 2! + 3!………100! by 7 ?
(c) Find a prime division of the form 4K+3 for the integer 4(3X7X!!X19)-1.

5. (a) What are custom controls ? Explain their use on the worksheet. Write the sequence
of steps for creating controls on the worksheet.
(b) List and explain different tools and services available on internet.

6. (a) Determine all 3 digits numbers N such that N is divisible by 11, and N/11 equals the
sum of the squares of the digits of N.
(b) Prove that for any positive x<1, the series 1+x+x2+x3 +--------xn converges to 1/(1-x) as n
tends to infinity.