Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 87 - 2619_PlusGPT V2.1_C-7
P. 87

    Relative References

                     By default, all cell references in Google Sheets are relative references. This means that when you
                     copy a formula across different cells, the references will automatically adjust based on their new
                     position in the sheet.

                     For example, if you copy a formula with a relative reference from one cell to another, the references
                     in the formula will change according to the new row or column. This helps keep the calculations
                     correct, depending on where the formula is copied.

                     To use relative reference, follow the given steps:
                     Step 1:  Select the cell that contains the formula for the reference of other cells.
                     Step 2:  Move the mouse pointer at the bottom right corner of the cell. The shape of the pointer
                              will change to + sign.

                     Step 3:  Drag the mouse till the last cell upto which you want to apply the formula.
                              The formula will be applied to the cells.

                                                                                               21 st
                      Let’s PraCtiCe                                                         Century   #Critical Thinking
                                                                                              Skills
                       If the cells A1, A2 and A3 contain 30, 40 and 50 respectively, then what will be the output of
                       the following formulas:

                       1.  (A1 - A2) * A3             _______________________________________________________
                       2.  A3 + (A1 * A2)             _______________________________________________________

                       3.  A1 * (A2 + A3) – 10        _______________________________________________________

                                                                                Formulas and Functions in Google Sheets  85

| 82 83 84 85 86 87 88 89 90 91 92 |