PC Software Skills

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

Q.1
(a) Given 13 cricket balls, one of them heavier than the rest, how can you determine it, in not more than 3 weightings, using decision tree?

(b) Explain the concept of filtering a database in MS-Excel using Autofiles and using Advanced filters.

(c) What is the difference between ‘Internet’ and ‘Network’? What is the role of TCP/IP in Internet? Also, list the hardware components used in the Internet.

(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.

(e) What is a template? Explain with an example.

Q.2
(a) Prove that for any prime up p>5, p²+2 is composite.

(b) What is the use of GOAL SEEK? Explain with an example.

Q.3
(a) Prove that for every integer n>2,
(n!)²>nⁿ

(b) What is meant by URL? What are its components?

Q.4
(a) Compare the different types of Internet connectivity mechanisms.

(b) Explain how the access of workbook in Excel can be restricted from other users.

Q.5
(a) Write short notes on any two of the following:
(i) HTTP
(ii) Telnet
(iii) FTP
(iv) Domain Name System

(b) Explain the following functions giving example for each:
(i) EXACT( )
(ii) IF( )
(iii) MOD( )

<< Previous

Next >>