University of Mumbai 2006 B.A Economics Computer Systems and Applications - Question Paper

(ii) discuss the following: - two
(I) MOD ( ) (II) RECNO (III) DTOC ( )
Q.2 (a) discuss briefly about the subsequent : - six
(i) HARD DISK (ii) WEBSITES (iii) WAN
(b) ans the subsequent in MS-EXCEL: four
A worksheet contains employee info such as name, basic pay and department entered in columns A, B and C respectively in 1st 25 rows. In 1st row heading is entered and in other rows data has been entered. discuss the steps to calculate DA, Additional Pay and Gross pay in columns D,E and F respectively using the policies. DA 90 % of basic pay for basic pay not exceeding Rs. 8000. otherwise it is 65 % of basic pay. Additional Pay Rs. 1500 for "SALES" department and Rs. 1200 for other departments. Gross Pay = Basic Pay + DA + Additional Pay (c) ans the subsequent in MS-EXCEL six
The subsequent data has been entered in a worksheet
A B C D E
1 Weight in Kgs (x) Frequency
(f) fx fX^2
2 48 three
3 52 seven
4 55 12
5 60 eight
6 68 six

discuss the steps to obtain the mean and standard deviation of weight using the formula:
Q.3 (a) ans in 1 or 2 lines the uses of : - six
(i) MODEM (ii) LAN (iii) SEARCH ENGINES
(b) ans the subsequent in MS-EXCEL : - four
discuss the difference ranging from Paste and Paste Special choice in edit menu
(c) ans the subsequent in MS-EXCEL six
Marks out of 100 scored by 40 students are entered in a worksheet in cells A3 to A42.
discuss the procedure to prepare a frequency table with class intervals as:
beneath 35, 35-45, 45-60,60 and above.
Q.4 (a) State whether the subsequent are actual or false : - six

(i) Both sides of CD-ROM can be used for data storage.
(ii) Floppy disk is a secondary storage device.
(iii) Windows Explorer is a Web Browser.
(iv) Post Office Protocol is used to fetch E-Mail.
(v) A serial printer prints 1 line at a time.
(vi) Every Computer requires Monitor.
(b) ans the subsequent in MS-EXCEL four

Earning:   Approval pending.