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

RR – 5105 Seat No ______
First Year M.Sc. (CA & IT) exam
March – April – 2002
PC. Software Paper : 105
Time : three hours] [Total Marks : 70

1 (a) ans the subsequent : (any three) 6

(1) Explain Batch file Command.
(2) What is Function of AUTOXEL.BAT File.
(3) What is standard INPUT and standard OUTPUT ?
(4) Explain ATTRIB Command.
(5) Explain MORE and SORT Command.
(6) Explain rules of Filename in DOS.
(b) discuss the subsequent : (any three) 6

(1) DISK Defragmerger
(2) MODEM
(3) Font
(4) Control Panel
(5) What is window ?

2 (a) Do as direct : 5

(1) OLE……… and GUI………..
(2) When a window is maximized it’s maximize button modifications to the …….......... button.
(3) If a file is deleted from the Recycle bin, windows can get easily back it. (True / False)
(4) Taskbar is always displayed at the button of the desk Top. (True / False)
(5) ……….. is the default extension of MS paint File.

(b) What is Mail Merge? Write a process of Mail Merge document. 5

OR

(b) What is word processing? provide a name of basic kinds of Tabstops and write a
process of Set a Tabstop.

(c) Fill in the blanks : 3

(1) Ctrl + Shift + = Command of ………….
(2) The macro command is located on the ……….. menu.
(3) ………… Key choose the entire table.
(4) In word, a document can be printed in the ………… or the ………… mode.
(5) Ctrl + M Command to ………….. in MS Powerpoint.

(d) What is Powerpoint? and write a various kinds of view of Presentation file. 3

3 (a) discuss the subsequent function : (any five) (Excel) 5

(1) PV ( )
(2) RATE ( )
(3) ROUND ( )
(4) SUBSTR ( )
(5) MOD ( )
(6) FACT ( )
(7) IF ( )

(b) ans the subsequent : (any three) 9

(1) What is a workbook and worksheet?
(2) What is the range? and discuss naming rangers.
(3) Explain pivot table, absolute cell and relative cell.
(4) What is a chart? and discuss any 2 chart.
(5) Discuss page setting facility in Excel with choice.

4 (a) what is a Database, table, record and field? 6

(b) Do as direct : 8

(1) You can include only 8 characters in a database name in Access. (True /
Fasle)
(2) You must have a primary key field. (True / Fasle)
(3) You can create a field name using UPTO ………… characters.
(4) Use ………… view to enter records in a table.
(5) Press ………….. to move to the 1st field in the record.
(6) An …………. is a ques. you ask of the database.
(7) The form Header / Footer menu item can be obtained on the …………. menu.
(8) The Report wizard has ………….., …………… and …………… kinds Layout.

5 (a) discuss the subsequent terms : (any four) 8

(1) Primary Key.
(2) Sorting a Data
(3) Qvery
(4) Logical function
(5) Parameter Query
(6) Conditional Formating
(7) Working with external Data

(b) ans the subsequent : (any two) 6

(1) Which are the various Data kinds in Access?
(2) What is Macro? and what is a Relation?
(3) What is a lookup? provide names of 2 Methods to create lookup.
(4) Discuss Report facility and mailing tags techniques in MS Access.

Earning:   Approval pending.