To make your formulas and functions work correctly, you need to refer to the cells and ranges you want. You can create references to cells and ranges in different locations:
To refer to a cell on the same worksheet, enter its column lettering and its row number. For example, use
=A10 to refer to cell A10.
You can either type in the reference or click the cell—whichever you find easier. You'll see examples of this shortly.
Similarly, to refer to a range, enter the range's address. For example, use
=A10:A20 to refer to ...