Page 66 - Computer Class 07

3. AVERAGE : ________________________________________________________

_______________________________________________________________________

4. RATE : ________________________________________________________
_______________________________________________________________________

5. NOW : ________________________________________________________
_______________________________________________________________________

B. Answer the following question.

1. Write the steps to enter a formula.
2. Write the steps to quickly perform sum of numbers.
3. Why functions are used?

4. Explain the various logical functions.
5. What do you understand by formula?

A. Create the following worksheet in MS Excel 2016.

Employee Employee Basic
HRA DA TA CCA Gross
Number Name Salary

1001 Jaspal 6500

1002 Dev Roy 8000

1003 Anwar 7000

1004 Rohit 6500

1. Calculate HRA (House Rent Allowance) as 30% of Basic Salary for all employees.

2. Calculate DA (Dearness Allowance) as 45% of the Basic Salary for all employees.
3. TA ` 500 fixed for all employees.

4. CCA ` 1500 fixed for all employess.
5. Calculate Gross as sum of Basic, HRA, DA, TA, CCA for all employees.

6. Save the workbook as ‘Salary’.
B. Mark a chart on Microsoft Excel 2016 displaying the types of functions. Display the

chart in the computer lab.

Computer-7 66 Computer-1