Page 61 - Artificial Intellegence_v2.0_Class_12
P. 61

Data Manipulation

            Data stored in a spreadsheet can be used for calculation, graphical representation and information display. Let us learn
            more about data manipulation.


            Per f or ming  C alculations
             o perform any calculation in a spreadsheet, use the ' '  equal to) symbol,  hich indicates that a formula has been
            entered. Only then will the spreadsheet perform the calculation and display the outcome.
              onsider the follo ing spreadsheet





























             o , let s calculate the total sales in each month.
             tep      Click the cell in which you want your answer.

             tep       ype      equal to) sign to start the formula.  lick on the cell  using the left mouse button) that contains the
                    value to be used in your formula.  alc  ill automatically pick up the cell address.   ou can also type in the cell
                    address)
































                                                                                            IC T S ki l l s- IV  59
   56   57   58   59   60   61   62   63   64   65   66