University of Mumbai 2006 B.A Economics Computer Systems and Applications - Question Paper
Friday, 12 July 2013 10:10Web
Page 3 of 5
(i) discuss the use of: three
(i) SUBSTR (ii) CDOW (iii) MIN ( )
(ii) discuss the following: two
(i) EDIT (ii) replace STRUCTURE.
part — I
Q.2 (a) discuss briefly about the following: six
(i) KEYBORAD (ii) LAN (Ili) TELNET.
(b) ans the subsequent in MS-EXCEL four
Roll no. and marks out of 100 scored in 2 subjects by 25 students are entered in a worksheet in columns A, B, C respectively in 1st 26 rows. In 1st row headings are entered and in remaining rows data has been entered. Write steps with suitable formulae to find:
(i) avg. marks in column D. (ii) To assign a remark (PASS or FAIL) in column E by using the subsequent policy. Remark is "PASS" if mark is 40 or more in both the subjects and avg. is 50 or more otherwise "FAIL".
(c) ans the subsequent in MS-EXCEL: six
Weights(in Kgs) of 50 children are entered in a worksheet in cells A3 to A52. By taking the class interval as 20-25, 25-30, 30-35, 35 and above. discuss the procedure to prepare frequency table.
Q.3 (a) ans in 1 or 2 lines the uses of : - six
(i) FLOPPY DISK (ii) OPERATING SYSTEM (iii) TCP/IP protocol.
(b) ans the subsequent in MS-EXCEL : - four
What is an Autofill List? discuss the steps to prepare the custom list (Custom Autofill) with the values Delhi, Mumbai, Bangalore, Chennai, Kolkata and display it in cells F1 to F5.
(c) ans the subsequent in MS-EXCEL six
Consider the subsequent worksheet showing the cost of machinery, scrap value and its life. Using straight-line method, discuss the procedure to display Year-wise depreciation and depreciated value for every year till the life of machinery. Use your own cell addresses.
A B C
1 COST SCRAP VALUE LIFE IN YEARS
2 200000 10000 10
3
4
Q.4 (a) State whether the subsequent are actual or false : - six
(i) Control Unit of CPU processes the data.
(ii) Dot Matrix Printer can be used for printing graphs.
(iii) Mouse is an Input Device.
Earning: Approval pending. |