Guru Nanak Dev University 2009-1st Year B.C.A Computer Application %2C PC Computing %2C tember %2C %2C Amritsar - Question Paper

Time Allowed : three Hours

Maximum Marks : 60

Note: Attempt any five ques. in all. All ques. carry equal marks.

1. What do you understand by formatting of worksheet? discuss the different kinds of formatting in worksheet. Write down different steps to set up a password on a worksheet.
[Marks 12]

2. Differentiate ranging from applications and documentation Windows. discuss every with the help of suitable examples.
[Marks 12]

3. elaborate the main features of windows vista? What do you mean by folder formats of a window? How can we change a window format? discuss with examples.
[Marks 12]

4. discuss the subsequent for a worksheet: [Marks 12]

(a) SORT
(b) SUMIF
(c) TAN
(d) RAND
(e) ROUNDUP

5. What is the advantage of mail merge? Write diwn different steps involved in producing a mail Microsoft Office 2003.
[Marks 12]

6. describe Macros. Create a MACRO to obtain that whether the entered number is prime number or not. [Marks 12]

7. define the different kinds of views in Microsoft Word. [Marks 12]

8. (a) How do you convert a provided text to a table using MS-WORD? discuss with the help of an example. [Marks 6]

(b) How will you convert a provided table to text using MS-WORD? discuss with the help of an example. [Marks 6]

Earning:   Approval pending.