Acharya Nagarjuna University (ANU) 2006 Diploma Computer Applications Computer Systems and Applications - Question Paper

* (i) MODEM (ii) LAN (iii) SEARCH ENGINES
* (b) ans the subsequent in MS-EXCEL : - 4
* discuss the difference ranging from Paste and Paste Special choice in edit menu
* (c) ans the subsequent in MS-EXCEL 6
* 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 : - 6
*

o (i) Both sides of CD-ROM can be used for data storage.
o (ii) Floppy disk is a secondary storage device.
o (iii) Windows Explorer is a Web Browser.
o (iv) Post Office Protocol is used to fetch E-Mail.
o (v) A serial printer prints 1 line at a time.
o (vi) Every Computer requires Monitor.
* (b) ans the subsequent in MS-EXCEL 4
* elaborate one-input and two-input tables?
* Using Data, Table command discuss how to prepare a one-input table to display simple interest values for a principal amount of Rs.20000 for a period of three years when the rate of interest varies as 4.5%, 5%, 6%, 6.5%, 8% per annum. Use your own cell addresses.
* (c) ans the subsequent in MS-EXCEL 6
The subsequent data has been entered in a worksheet
A B C
one Name Dept. Salary
two RAJAN STORES 12,000
three SUMA ACCOUNTS 15,500
four KIRAN PRODUCTION 18,000
five JAYESH ACCOUNTS 9,600
five AMIT PRODUCTION 22,000
five ARTI STORES 11,600
* Based on these values, write steps to
o (i) organize the data in the order of Dept and further in the order of Name.
o (ii)To display only those rows where salary is above Rs. 15000.
o (iii)To display all the rows other than the 'STORES' dept.
* Q.5 (a) discuss briefly about following: - 6
o (i) Non -impact Printer (ii) TCP/IP protocol (iii) UNIX
* (b) ans the subsequent in MS-EXCEL 4
* State whether the subsequent are actual or false: -

Earning:   Approval pending.