The syntax is straightforward when referencing cells or ranges in the same worksheet. For example, to reference the cell A1, you can type "=A1" into another cell. However, when referencing cells or ranges in a different worksheet, you need to include the sheet name in the reference.