Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    Step 2:  Press Shift key and Arrow keys to select a desired cell range.

                      Step 3:  Release the Shift key.
                               The cell range will be selected.

                             CELL REFERENCING IN FORMULAS AND ITS TYPES

                      A cell reference is like the address of a cell in Google Sheets, and it can be used in formulas to
                      refer to a specific cell. When you use a cell reference in a formula, the result depends on the values
                      in the referenced cells. If you change the value in the referenced cell, the result of the formula will

                      automatically update.
                      To see this in action, type 10 in cell A1. Then, click on cell A2, type =A1*2, and press Enter. The
                      value in cell A2 will be 20. If you change the value in A1 to something else, the value in A2 will
                      automatically change to match the new calculation.

                                          Using cell reference                      After changing values

                      Cell references are especially helpful in case of complex formulas. There are three types of cell
                      references used in Excel: relative, absolute and mixed.

                      84    Premium Edition-VII

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