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

B-12705 Seat No.
First Year M.Sc. (CA & IT) exam
May/June-2001
PC Software : Paper – 105
Time : three Hours ] [Total Marks : 35

1 (a) Answer in 1 line : (any six) 6
(1) What is booting ?
(2) What is batch file ?
(3) What is wild card ?
(4) Explain PROMPT and kind command.
(5) What is difference ranging from Internal and External command in DOS.
(6) What are File attributes ?
(7) What is difference ranging from Internal and External command in DOS.
(8) Explain Filter command.
(B) Explain : (any three) 6
(1) Folder and file
(2) Types of icon
(3) Disk defragmenter
(4) Network Neighborhood
(5) Window terminology

2 (a) Do as directed : 5
(1) Double click any where in the word. To choose a line. (True / False)
(2) F7 in word provide facility to check spelling. (True / False)
(3) With window 95/98 filename can be up to 286 characters. (True / False)
(4) Press Ctrl + Enter Command to insert a Hard page break. (True / False)
(5) Is the default extension of power point file.

(b) Explain mail merge facility in M.S. word. 5

OR
(b) Write a word advantage and discuss Auto text and Auto accurate.

(c) Fill in the blanks. 3
(1) The cut , copy and paste commands are located on the menus.
(2) WYSIWYG ___________. .
(3) __________ is the Function key used for slide show.
(5) Field name must be less than _________ characters in mail merge Data field.
(5) Ctrl + E command to __________. .

(D) What is power point and write components of M.S. power point. 3

3 (a) Explain the subsequent function (Excel) : (any five) 5
(1) PMT( ) (5) MAX( )
(2) ROUND ( ) (6) FU ( )
(3) LEN ( ) (7) WEEKDAY ( )
(4) PROPER ( )

(b) Answer any 3 : 9
(1) a short note on special kinds of range.
(2) What is function and formula ?
(3) Explain Absolute reference cell Auto complete, Auto Fill.
(4) Explain subsequent terms :
Workbook Cell
Pivot table Goal seek

4 (a) Explain terms Database, Tables and fields. 6
(b) What is database ? discuss primary key. 4
(c) Explain the difference ranging from sorting and Indexing discuss briefly. 4

5 (a) Explain term form : 8
How it is useful in development?
Discuss any 4 important functionality.
OR
(a) Answer the subsequent :
(1) Write various properties of the field.
(2) Give meaning of inner join and outer Join.
(3) What is a filter ?

(b) explain subsequent terms : (any 6 ) 6
(1) Macros.
(2) SQL
(3) Relationship
(4) Lookup
(5) UPC
(6) Group by
(7) Table wizard
(8) Arrays

Earning:   Approval pending.