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

(iii) By default, MS-WORD saves a document in My Documents folder.
(d) ans the subsequent in Fox-Pro: three
(i) discuss the use of: three
(i) INT ()(ii) DTOC( ) (iii) LTRIM()
(ii) discuss the following: two
(i) INPUT TO (ii) SET DEFAULT TO
part — I
Q.2 (a) discuss briefly about the following: six

(i) HARD DISK (ii) TCP/IP PROTOCOL. (ill) OPERATING SYSTEM.
(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

There is a worksheet where the values of x and its corresponding frequency (f) are entered in cells 62 to B6 and C2 to C6 respectively. discuss the procedure to obtain mean (x) and mean deviation from mean, showing calculations of fx and fIx – x lin columns D and E respectively using the subsequent formula.
Q.3 (a) ans in 1 or 2 lines the uses of : - six
(i) MOUSE (ii) LAN (iii) INTERNET
(b) ans the subsequent in MS-EXCEL : - four
discuss how to create link ranging from 2 workbooks and the purpose for linking workbooks
(c) ans the subsequent in MS-EXCEL six
Consider the subsequent worksheet showing original value of an asset, its useful life and rate of depreciation Wannum.

A B C
1 Asset Life in Years Rate of Depreciation
2 500000 eight 10%
3


Using reducing balance method, discuss the steps to display Year wise depreciation and depreciated value (WDV) for the 1st 8 years of life of asset. Use your own cell addresses.
Q.4 (a) State whether the subsequent are actual or false : - six

Earning:   Approval pending.