The ability to cross-reference data, and to use the result of one calculation as the basis for another, is fundamental to spreadsheets. By using cell references your data can stay live throughout a chain of calculations, so that if you change the original data for the first calculation, all further calculations referring to it are automatically updated without any further effort from you.
You can type a cell reference into a number cell. When evaluating the formula, Fireworkz uses the value of the referenced cell, which may itself be the result of a formula. If you were working with a large worksheet and wanted to create a summary section, this is one way to do it. If the value of the referenced cell changes, the value in the cell containing the reference is updated too.
You should always make a reference to a cell rather than typing its value into a second cell as a constant. If the value changes (perhaps because you discovered an error earlier in your worksheet) the reference will be updated, and the new figure automatically passed on to further calculations which need it.
To enter a cell reference:
When you type another character, enter a function or operator, or enter another cell reference, the grey highlight disappears. The cell reference is no longer subject to special treatment.
You can now edit the elements of the cell reference individually, for example, replacing the row or column part of it.