Page 21 - Touchpad_Plus_V3.2_Class 7
P. 21

Envision your favourite tech personality as a Gizmo Gadget. How would you paint their
                                   portrait in Calc?



                 You can also use cell addresses to perform calculation in the following way:







                                                     Using cell addresses in formula
                 Notice that when the cell C1 is selected, the Formula bar shows
                 the formula you just typed.
                    What appears in the cell is the result.

                     ✶ What appears in the formula bar is the value, which is a
                    formula in this case.
                 The elements of a formula are:                                         Using cell addresses in formula
                    References: A cell or a range of cells that you want to use in your calculation.

                    Operators: Symbols (+, -, *, /, ^, $, %, etc.) that specify the calculations to be performed.
                    Constants: Numbers or text values that do not change.


                 Copying a Formula
                 There are two methods to copy a formula.

                 Using the Fill Handle

                 Step 1  Select  the  cell  that  contains  the  formula,  then
                          position  the  mouse  pointer  over  the  lower-right
                          corner of the cell until the white cross (  ) appears.
                 Step 2  Drag the fill handle over the cell or cells to which
                          you want  to copy the formula, then release the
                          mouse button.

                 Using Copy and Paste

                 Step 1  Select the cell that contains the formula, and from the Edit menu,
                          click on Copy option.
                 Step 2  Select the cell or cells that you want to copy it to.
                          (a)   To copy the formula and any formatting, from the Edit menu, click Paste.

                          (b)  To  copy  the  formula  only,  from  the  Edit  menu,
                              hover the mouse pointer over Paste Special option
                              and click on  Paste  Only  Formula option from the
                              sub-menu.



                                                                        Formulas, Functions and Charts in Calc       19
   16   17   18   19   20   21   22   23   24   25   26