EXCEL PRACTICAL ASSIGNMENT FOR STUDENTSEXCEL PRACTICAL ASSIGNMENT FOR STUDENTS

__Assignment 1__Type the following data in excel worksheet and save it as first.xls

Type the following data in excel worksheet and save it as first.xls

A B C D E

513

501

504

513

511

516

532

504

432

501

510

517

479

494

498

Do the following

(a) Highlight column A and copy it to column C

(b) Sort the data in column C in ascending order

(c) What is the lowest number in the list (use a function)

(d) Copy the data in column A to column E and sort it in descending order

(e) What is the highest number in the list (use a function)

(f) How many numbers in this list are bigger than 500 (use a database function)

(g) How many numbers in column A are between 520 and 540 inclusive

(use a database function)

**Assignment 2.**

Type the following data in excel worksheet and save it as second.xls.

A B C D

People per physician Life Expectancy

X Y X * Y

370 70.5

6166 53.5

684 65

449 76.5

643 70

1551 71

616 60.5

403 51.5

Do the following

(a) Complete column C for finding product x * y

(b) Find sum of x column at the end of data

(c) Find sum of y column at the end of data

(d) Find sum of x * y column at the end of data

(e) Find sum of x^2

(f) Find sum of y^2

**Assignment 3.**

Enter the following data and save it in grade .xls

Name Marks1 Marks2 Marks3 Total Percentage Grade

Amit 80 70 80

Renu 70 60 90

Rajeev 60 50 80

Manish 50 30 90

Sanjeev 40 40 80

Anita 70 70 90

Do the following

(a) Compute the total marks and percentage of each student by entering appropriate formula.

(b) Compute the grades based on following criteria

If percentage >= 90 then grade = A

If percentage >= 80 and <90 then grade = B

If percentage >= 70 and <80 then grade = C

If percentage >= 60 and <70 then grade = D

If percentage < 60 then grade = E

**Assignment 4.**

Using grade.xls to perform the following formatting operations

(a) Draw a border around the worksheet

(b) Change the font size of heading to 14 points and underline it and hide column c

(c) Increase the width of column A to 15 characters

(d) Right Align the values in column B, C, F

**Assignment 5.**

A university maintains a year wise result for four courses and then generates an average report as given below

Sr no. Year Course1 Course2 Course3 Course4 Average

1 2002 356 300 300 400

2 2003 200 400 200 450

3 2004 256 500 400 600

4 2005 400 600 500 550

5 2006 456 450 550 450

6 Total

(a) Complete the report to calculate the course wise average in row 6

(b) Provide formula to calculate year wise average in column G

(c) Generate a column chart to compare data

**Assignment 6.**

A person wants to start a business and he has four schemes to invest money according to profit and years. Find out which scheme is the most profitable.

Investment Amount Percentage for Profit No of years

20000 10% 6 years

40000 20% 5 years

14000 30% 4 years

12000 15% 5 years

**Assignment 7.**

A company records the details of total sales (in Rs. ) sector wise and month wise in the following format

Jan Feb March April

Sector 30 12000 17000 14000 15000

Sector 22 14000 18000 15000 16000

Sector 23 15000 19000 16000 17000

Sector 15 16000 12000 17000 18000

(a) Enter the data in a worksheet and save it as sector.xls

(b) Using appropriate formula, calculate total sale for each sector

(c) Create a 3-D column chart to show sector wise data for all four months

(d) Create a 3-D pie chart to show sales in Jan in all sectors

**Assignment 8**

## No comments:

## Post a Comment