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

First Year M. Sc. (C. A. & I. T.)Examination
August - 2002
P. C. Software : Paper - 105
Time : three Hours] [Total Marks : 70
1 (a) What is command processor ? Write the 1
function of it.
(b) What is difference ranging from internal and 2
external command.
(c) Write down a command to : (any three) 3
(1) List all files and directories containing more than
three characters page by page.
(2) List all files which is exactly of 172 bytes.
(3) List only files not directories in alphabetical order.
(4) List all files having extension exe and doc.
(5) Make the sample.txt file as learn only file.
2 ans any 2 of the subsequent : 6
(a) What is difference ranging from dos and windows.
(b) What is Windows Explorer ? How can we select, copy,
move, rename file or folder in it ?
(c) How can we create a short-cut in windows ?



3 (a) ans any 2 of the subsequent : 12
(i) Write the use of Mail-Merge. discuss it stepwise with
proper example. provide idea of Master document and data document.
(ii) provide the difference ranging from every of the subsequent :
(1) Widow and orphan control.
(2) File -» Save and File -> Save As command.
(3) Paste and paste special.
(iii) Write down keyboard short-cuts for the subsequent :
(1) To create a new document.
(2) To save an already open document.
(3) To open print dialog box.
(4) To open page-setup dialog box.
(5) To align a snippet to left.
(6) To align a snippet to center.
(b) Write down steps involved to create a 6
presentation.
OR
(b) What is template ? How is it different 6
from slide master ?

4 ans any 2 of the subsequent : '12
(a) What is pivot table ? explain its utility.
(b) provide the difference ranging from every of the subsequent :
(1) Absolute reference and relative reference.
(2) Workbook and worksheet.
(3) Function and formula.
(c) discuss the subsequent function : (any three)
(1) Count IF
(2) Not
(3) Month
(4) PMT
(5) Upper.
5 (a) What is Database ? explain the importance 5
of primary key with example.
(b) What is difference ranging from sorting and 5
indexing ?
(c) What do you mean by data kind ? Can a 4
database exist without data kind ?
6 (a) discuss the use of Form with example. 8
OR
(a) discuss the use of report generation facility with example.





(b) ans any 2 of the subsequent : 6
(1) describe field. explain properties of it.
(2) explain various kinds of join.
(3) discuss the subsequent term :
(i) Macro
(ii) Filtering
(iii) SQL.

Earning:   Approval pending.