Page 165 - Computer - 7
P. 165

A cell is the intersection of a row and a column. Columns are identified by letters – A, B, C, … while
            rows are identified by numbers – 1, 2, 3, … Every cell has its own reference, called Cell Address, made
            up of the column letter and the row number, e.g., B3.

            Using Formulas
            A formula is an expression that performs calculations and manipulations on data and produces a
            result. A formula starts with an equal to (=) sign and is followed by an expression made up of values,
            cell references, and operators.
            To use a formula in a spreadsheet:

            1.  Create the worksheet as shown earlier.
            2.  In cell G2, type the formula = D2 + E2 + F2












                 A coloured dotted border appears around each cell referenced in the formula and the formula
                also appears in the Formula bar. The result of the formula is previewed above the cell.
            3.  Press the Enter key.

















                 The result of the formula is displayed in cell G2. The Autofill feature in Google Sheets displays the
                result of the formula in the cell range below cell G2.

            4.  Click the Tick     button to accept the formulas in the remaining cells.

           Google  Sheets  uses  the  method  of  BEDMAS  (Brackets,  Exponentiation,  Division,  Multiplication,
           Addition, Subtraction) to ascertain the precedence and order of the calculations in a complex formula
           involving more than one operator.

            Using Functions
           A function is a predefined formula that performs calculations using specific values in a particular
           order. Google Sheets provides many inbuilt functions, such as Sum, Average, Count, Max, and Min to
           perform calculations. A function also starts with an equal to (=) sign. A function may contain one or
           more arguments. Arguments are the values or cell references that contain the values on which you
           want to apply the function.


                                                                                                             163
   160   161   162   163   164   165   166   167   168