Manipulation of Cells and Sheet



Example Programs



Program [1]

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


Name
Phone
Floor
Office
Dept
Design
Salary
Neha
5834
211Admin
PM
8000
Sucheta
2812
221Admin
CL
9000
Amrit
3477
117Mkt
CL
10000
Arunesh
6992
314Mkt
MM8500
Ashwin
1538
312Mkt
SI5000

(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/-.


View Solution

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
12014
300
650
560

22015
450
500
400

32016
490
400
250

42017
600
650
350

52018
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.


View Solution

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
12014
300
650
560

22015
450
500
400

32016
490
400
250

42017
600
650
350

52018
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.


View Solution

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


View Solution

CCC Online Test 2021 CCC Practice Test Hindi Python Programming Tutorials Best Computer Training Institute in Prayagraj (Allahabad) O Level NIELIT Study material and Quiz Bank SSC Railway TET UPTET Question Bank career counselling in allahabad Website development Company in Allahabad Sarkari Exam Quiz