Gujarat University 2008-1st Year B.C.A Computer Application PC Softwares - Question Paper
Scat No.: _3 5
April-2008 ,
BCA-IU6 : PC Software (Nov Course)
rime: 3 Hours) | Max. Marks : 70
I. A. Answer the following:
(i) Explain the use of wildcards with example. 3
(ii) What docs the following DOS Command do ? 2
(a) C:\windows'\typc tcsUxl
(b) C:\windows\delcte a:\*.doc
(iii) Differentiate: DOS based PC & Windows based PC. 2
IJ. Dq as directed.
(i) Differentiate : TODAY( )& NOW () functions in MS Excel. 2
(ii) List out different types of cell references in MS Excel. Explain any two in detail. 3
(iii) What arc the advantages of formula in MS Excel ? 1 low one can enter it in a cell ? 2
OR
A. Answer the following :
(i) Define Operating System. List out any four roles of it. Also give the name of any-four popular operating systems. 3
(ii) Explain COPY & MOVE commands in DOS with example. 2
(iii) What is tile ? What do you mean by naming convention of.? file ? 2
V*
B. Do as directed.
(i) What is a chart ? Explain pic chart in detail. 2
(ii) Which are the different typcsyof errors in MS Excel ? Explain any two with example. 3
(iii) What is the use of paste & paste spccial ? 2
2. A. Answer the following : (any ten) 10
- (i) What is icon ? %
(ii) What is the use of Recycle bin ?
P.T.O.
I
FBCA-07
(iii) F.xplain the significance of Desktop.
(iv) What is the utility of My Computer?
(v) Define: Client & Server.
(vi) What docs SCANDISK command do in DOS ?
.(vii) Write any one method to delete a folder from windows explorer.
(viii)What is the use of search option of a Stan menu in windows operating system ?
(ix) How one can create a short cut for any application on Desktop ?
What is task bar ?
(xi) What do you mean by disk de-fragmentation ?
(xii) What is Network Neighborhood ?
(xiii) What is work station ?
Ii. Answer the following : (any two) 4
(i) What are computer viruses ? Give any four ways by which they can spread ? 3 k (ii) Give any four viruses name & explain the harmfulncss of any two.
(iii) How one can prevent & curc a computer from computer viruses ?
(iv) List out any eight symptoms of computer viruses.
3. A. State as Truc-T'alsc. 4
(j) In MS Word, lr4 key is used for Spelling & Grammar chccking.
(ii) Macro is available under 'I ools menu.
(iii) IN Page Setup, gutter margin is used for binding.
(iv) In MS Word, the default tab stop value is 0.5
(v) In MS Word, by default view is normal view.
B. Answer the following (any five) 10
(i) What is the use of mail merge facility in MS Word ? Which two files arc
v" used for it ?
Jii) Differentiate : Auto Text & Auto Correct.
(iii) Kxplain endnote & footnote with example.
(iv) In MS Word, what is the utility of replace command ? Under which menu it is available ?
jv) What do you mean by bookman & commcnt ?
FBCA-07 2
--(vi) Explain hanging paragraph with example.
(vii) In MS Word, what is template ? What is the extension of a template file ? ii) What is hyperlink ? How one can create it in a document ?
4. A. Answer the following in MS Excel, (any four) 4
(i) Define Worksheet. %
(ii) What is the use of freeze panes under window menu ?
(iii) What docs UPPER() function do ?
(iv) What is the use of data consolidation ?
(v) What do you mean by merge cell T
(vi) What types of data one can enter in a worksheet ?
(vii) What will be (he output for: = ROUND (12.35,-1)
B. Answer the following (any five): 10
(i) Explain the use of SUM() and SUM1F() functions. %
%
(ii) What is Macro ? Write down the steps to create it.
(iii) What do you mean by Auto filter & Advanced filter ?
(iv) Explain formatting & conditional fonnatting.
(v) Differentiate HLOOKliP( ) & VLOOKUP( ).
(vi) What is Goa! Seek & Scenario ?
(vii) What is the use of data form & data validation ?
(viii) Define Cell & Range.
5. A. Answer the following, (any five) 10
(i) What is presentation ? What types of presentation arc available in Auto
Content Wizard of MS PowerPoint ? 5
Sw/(ii) Explain the utility of Pack & Go facility of MS PowerPoint.
(iii) What is custom show ?
(iv) List out different types of views in MS PowerPoint. Explain any two.
(v) What is custom animation ? How one can apply it ?
(vi) What is a slide ? List out any four layouts of it.
What is the use of Rehearse liming?
(viii) Write any two methods for inserting a new slide in MS PowerPoint presentation.
FBCA-07 3 P.T.O.
13. Answer the following (any two):
(i) What is the use of MS Outlook Express ? State the significance of address book of it.
(ii) Explain Outbox & Sent items box of MS Outlook Express.
(iii) What is the importance of Drafts box in MS Outlook Express ? t
(iv) Differentiate cc & bcc in MS Outlook Express.
i
FBCA-07 A
|
Attachment: |
| Earning: Approval pending. |
