Page 62 - Web Applications (803) Class 12
P. 62

Step 3:    Click on the Print button; the worksheet will be printed.






























                      Data Manipulation


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


              Performing Calculations
              To perform any calculation in a spreadsheet, use the '=' (equal to) symbol, which indicates that a formula has been
              entered. Only then will the spreadsheet perform the calculation and display the outcome.
               Consider the following spreadsheet:





























              Now, let’s calculate the total sales in each month.
              Step 1:   Click the cell in which you want your answer.

              Step 2:    Type ‘=’ (equal to) sign to start the formula. Click on the cell (using the left mouse button) that contains the
                       value to be used in your formula. Calc will automatically pick up the cell address. (You can also type in the cell
                       address)

                    60      Touchpad Web Applications-XII
   57   58   59   60   61   62   63   64   65   66   67