Cell Reference

A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

In one or several formulas, you can use a cell reference to refer to:

• Data from one cell on the worksheet.
• Data that is contained in different areas of a worksheet.
• Data in cells on other worksheets in the same workbook.

For example:

This Formula:                      Refers to:

=C2                                            Cell C2

=Asset-Liability                          The cells named Asset
                                            and Liability

{=Week1+Week2}                            The cell ranges named
                                            Week1 and Week2

=Sheet2!B2                                Cell B2 on Sheet2

Source: http://office.microsoft.com