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
   54   55   56   57   58   59   60   61   62   63   64