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

* (b) ans the subsequent in MS-EXCEL: -
* (i) discuss the use of the subsequent functions 2
* (I) MAX ( ) (II) UPPER ( )
* (ii) discuss how to save a worksheet with a Password for protection. 2
* (iii) discuss how to add a new row after the 10 row. 1
* (c) State whether the subsequent are actual or false: - 3
*

o (i)DOS is multitasking Operating System.
o (ii)In MS-WORD menu bar is always displayed while editing a document.
o (iii)In MS-WORD, PAGE SETUP choice allows you to add page number to a document.
* (d) ans the subsequent in FoxPro: -
*
* (i) discuss the use of: - 3
* (I) MOD ( ) (II) RECNO (III) DTOC ( )
* (ii) discuss the following: - 2
* (I) MOD ( ) (II) RECNO (III) DTOC ( )
* Q.2 (a) discuss briefly about the subsequent : - 6
* (i) HARD DISK (ii) WEBSITES (iii) WAN
* (b) ans the subsequent in MS-EXCEL: 4
*
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 6
*
The subsequent data has been entered in a worksheet
A B C D E
one Weight in Kgs (x) Frequency
(f) fx fX^2
two 48 3
three 52 7
four 55 12
five 60 8
six 68 6
*
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 : - 6

Earning:   Approval pending.