Q.1. (a) Three married couples are to cross a river in a boat which can hold only two persons. one of whom must row the boat. Each of the three husbands is a jealous man who will not allow his wife to be left in the company of other men, unless he is also present. Show how the jealous husbands and their wives can accomplish the trip by labelling all the states on the left and right banks of the river.
(b) What are Macros ? Explain two difterences between Macros and Templates.
(c) What is "Alignment" ? Explain the four alignment options which can be used for document alignment.
(d) What is a URL in Internet ? Explain the fields of a URL through an example.
(e) What is a Domain Name System (DNS) ? What are the bases of classifications of DNS ? Explain with two examples each.
Q.2. (a) What are dialog boxes ? Explain the steps to create and run a dialog box.
(b) What is a protocol ? Explain any two commonly used Internet protocols.
(c) What is Format Painter ? Give the steps involved in applying Format Painter.
Q.3. (a) What is a Search Engine in Internet ? List any six search engines available on Internet.
(b) What is the remainder left after dividing
1!+ 2!+ 3! + . . . + 100! by 7 ?
(c) Write three differences between a work book and a work sheet.
(d) 'Databases can be created in MS-Excel.' True or False ? Give reasons for your answer. (2)
Q.4. (a) Explain the meaning and purpose of the following :
(i) AutoFormat
(ii) Pivot Table
(iii) Custom Control
(b) Give the steps involved in applying advanced filters in a work sheet.
(c) What are the uses of charis in Excel ? What is a Chart Wizard ? Explain two different types of charts.