Gujarat University 2007 B.C.A Computer Application PC Software ( : 106) (New ) - Question Paper

FBCA-06
April-2007
PC Software (BCA : 106)
(New Course)

Seat No. :




Time : three Hours] [Max. Marks : 70



l. A. Answer the subsequent ques. :

i. What is an operating system ? Differentiate ranging from single user and multi user operating system. 03

ii. Using an example show the utility of * and ? in DOS. 02

iii. What is the difference ranging from the subsequent DOS commands ? 02

(a) COPY and REN

(b) DIR*.* and DIR hello.c

B. Answer the subsequent :

i. What is data validation in Excel ? How do we achieve it ? 03

ii.
What is the difference ranging from IF() and SUMIF() functions in Excel ?
02

iii.
What do you understand by freeze panes in Excel ?
02

OR


A. Answer the subsequent ques. :

i. What happens during the booting process and why is it needed ?

Compare warm boot with cold boot. 03

ii.
How would you compare DOS and WINDOWS operating systems ?
02

iii.
What do the subsequent commands in DOS do ?
02

(a) PROMPT Exam$D$T$G

(b) COPY c:\exam\*.* /



B. Answer the subsequent :

i. What is the difference ranging from auto filter and advanced filter in Excel ? 03
ii. What is goal seek in Excel ? 02
iii. What is a custom list in Excel ? How do we create it ? 02


2. A. Answer the subsequent ques. (any five) : 10

i. State the concept of client and server.

ii. What is the significance of a ‘taskbar’ in Windows ?

iii. How does ‘control panel’ help the user ?

iv. Why is it important to ‘shut down’ before switching off the system ?

v. What is a ‘workstation’ ?

vi. State the utility of ‘Network Neighbourhood’.

vii. What is a desktop ? What do we mean by customizing a desktop ?

viii. discuss the significance of ‘Windows Explorer.

B. Answer the subsequent : (any two) 04

i. Differentiate ranging from cc and bcc in Outlook.

ii. State the significance of the ‘task folder’ in Outlook.

iii. What is the importance of the ‘notes’ folder in Outlook ?

iv. What is the significance of an address book in Outlook ?



3. A. Answer the subsequent ques. : 06

i. What is the difference ranging from autotext and autocorrect feature in Word ?

ii. What is the use of ‘Book Mark’ in Word ? How do we create it ?

iii. What is utility of the mail merge feature in Word ?

OR

ans the subsequent ques. : 06

i. What is the use of a dictionary in Word ? Can we create it ? If yes, how ?

ii. What are ‘tabs’ in Word ? define in brief the kinds of tabs in Word.

iii. How would you differentiate ranging from Paste and Paste Special feature of
Word ?



B. Describe the subsequent in a Word document : (any four) 08

i. ‘Comments’ in a word document.

ii. ‘Find whole words only’ in obtain and change choices iii. Footnote and Endnote
iv. Thesaurus v. Book mark
vi. Different kinds of views vii. Hanging snippets
viii. Password to open and Password to replace



4. A. Answer the subsequent : 10

i. What do you understand by slide transition in PowerPoint ? How do we customize it ?

ii. What are speaker notes in PowerPoint ?

iii. What do you mean by ‘rehearse timings’ in PowerPoint ?

iv. State the significance of a slide sorter in PowerPoint.

OR

A. Answer the subsequent : 10

i. What is animation in PowerPoint ? What is its kind ?

ii. What are custom indicates in PowerPoint ?

iii. How would you differentiate ranging from slide layout and slide design ?

iv. Explain Pack and Go Utility.

B. Answer the subsequent ques. : (any two) 04

i. What are computer viruses ? Mention at lowest 5 symptoms of computer virus.

ii. Describe the ways in which computer viruses can spread. iii. Mention the major kinds of viruses. discuss any two.
iv. What are the ways of preventing and curing computer viruses ?



5. A. Differentiate ranging from the subsequent in Excel (any five) : 10

i. Worksheet and Workspace

ii. Cell addresses : A$4 and $A4

iii. Paste and Paste Link iv. Cell and Range
v. Global macros and Local Macros vi. ? and Subtotals
vii. Auto Format and Conditional Formatting viii. Wrap text and Shrink to fit
B. Answer the subsequent : 04

i. What do you understand by creating a ‘new Window’ in Excel ?

ii. What are data tables in Excel ?

OR

ans the subsequent : 04

i. What is the significance of ‘split’ under Window choice in Excel ?

ii. What are the kinds of data that can be entered in an Excel sheet ?

Earning:   Approval pending.