#### Example Programs

Program [1]

(a) Create a worksheet "employee" with the following information.

 Name Phone Floor Office Dept Design Salary Neha 5834 2 11 Admin PM 8000 Sucheta 2812 2 21 Admin CL 9000 Amrit 3477 1 17 Mkt CL 10000 Arunesh 6992 3 14 Mkt MM 8500 Ashwin 1538 3 12 Mkt SI 5000

(b) To find floor in which there is no person whose name starts with A.

(c) To display name and office for the persons in office 11 and 14.

(d) To extract name and phone for the persons on the floor between 2 and 4.

(e) To extract name and office for persons of Admin department.

(f) To extract name and phone for the persons having salary more than 8000/-.

Program [2]

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

 SR NO YEAR COURSE1 COURSE2 COURSE3 AVERAGE 1 2014 300 650 560 2 2015 450 500 400 3 2016 490 400 250 4 2017 600 650 350 5 2018 500 550 450

(a) Create the worksheet shown above.

(b) Save the file with name "Courses".

(c) Use the AutoFill to put the SR NO. into cells.

(d) Set the column widths as follows : Column A : 8, Column B : 14, Columns C & D : 15, Columns E & F : 14.

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

(f) Provide formula to calculate year wise average in column F.

Program [3]

1. A university maintains a year wise result for three courses and then generates an average report as given below :

 SR NO YEAR COURSE1 COURSE2 COURSE3 AVERAGE 1 2014 300 650 560 2 2015 450 500 400 3 2016 490 400 250 4 2017 600 650 350 5 2018 500 550 450 Course Wise Average

(a) Create the worksheet shown above.

(b) Save the file with name "Courses".

(c) Use the AutoFill to put the SR NO. into cells.

(d) Set the column widths as follows : Column A : 8, Column B : 14, Columns C & D : 15, Columns E & F : 14.

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

(f) Provide formula to calculate year wise average in column F.

Program [4]

Create a table in MS-Excel as shown below:

 Roll No. Name Marks in English Marks in Maths Total Marks 1. Rahul 85 95 2. Ronit 65 50 3. Amit 72 80 4. Rupesh 40 60 5. Shivika 35 60 6. Garima 87 91

Do the following:

a) In the total marks column, entries should be calculated using formulas and it is the sum of marks in physics and marks in chemistry.

b) Insert a new row at the end of the table and also find grand total using formula.

c) Sort the table based on total marks.

d) All columns should be center aligned.

e) Heading should be in bold and underlined