Page 86 - 2619_PlusGPT V2.1_C-7

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