Page 59 - IT-802_class_12
P. 59
In the picture below, the formula =C3+D3+E3 is used to calculate the total marks scored by every student.
3.4.2 Editing Data in a Cell
Spreadsheets are composed of columns and rows that create a grid of cells. Typically, each cell holds a single item of
data. Data can be classified into numeric, alpha-numeric, or text, date/time, and formula.
There are various methods to edit or change data in a cell:
Let us consider an example of the marks of 5 students in 3 subjects and a total of that. For that, Roll no., Name, marks
scored in 3 subjects, and Total. A spreadsheet can be used to enter all this data.
Suppose Rohit’s marks in science are to be changed from 65 to 70.
Method 1
1 Select cell E3 by double-clicking on it.
1
2 Then, in the cell, type the data that is to be changed.
ICT Skills-IV 57

