Hemchandracharya North Gujarat University 2003 B.Sc Computer Science 105 : Basic Microcomputer Application - Question Paper

D-3505 Seat No..
First Year M. Sc. (IT & CA) exam
October / November - 2003
Paper - 105 : PC-Software
Time : Hours] [Total Marks : 70
1 ans the subsequent : 10
(1) What is batch file ?
(2) What is booting ?
(3) Write down the full path of winword.exe.
(4) List files whose 2nd character is p, 2nd last character is y and the extension starts with e.
(5) What is difference ranging from RD and DELTREE commands ?
(6) What is Clipboard ?
(7) What is Screen Saver ?
(8) What is difference ranging from File and Folder ?
(9) How can you rename a folder ? List all possible ways.
(10) What is autoarrange and line up icons facility ?
2 ans the subsequent : (any two) 12
(a) (1) discuss Disk Defragmentation
(2) Write short note on *My Computer'.
(b) Write difference ranging from :
(1) Widow and Orphan
(2) Caption and Bookmark
(3) Docking toolbar and Floating toolbar.
(c) discuss about various features of global text finding and replacement.
3 ans the subsequent : (any three) 12
(a) discuss what — if analysis tools in brief.
•*
(b) How can you filter data using Auto filter and Advanced filter ? discuss it with proper example.
(c) discuss subsequent functions :
(1) PV ( ) ^
(2) COUNT IF ( )
(3) RIGHT ( )
(4) TRUNC ( ).
(d) What do you mean by cell formatting ? explain the various aspects of formating.

4 (a) ans the subsequent : (any two) 8
(1) What is presentation ? discuss various views of slide presentation.
(2) discuss custom animation and slide transition features.
(3) What are the steps to perform the subsequent operation ?
(i) To set timing ranging from 2 slides
(ii) To insert Date and Time
(iii) To provide background
(iv) To provide sound effect.
(b) What is field ? Write various properties four of the field.
k,
5 ans the subsequent : (any three) 12
(a) discuss primary key and objective of the primary key.
(b) What is look up ? provide names of 2 methods to create lookup.
(c) What is Query ? discuss update query.
(d) Write name of various report layouts ? Write difference ranging from Column report and Tabular report.
6 Answer the subsequent : (any three) 12
(a) What is form ? discuss how we design a form.
(b) provide difference ranging from link table and import table.
(c) discuss foreign key with example. _
(d) discuss difference ranging from Sorting and Indexing. discuss briefly.

Earning:   Approval pending.