Key Points
You can add a group of cells to a formula by typing the formula and then, at the spot in the formula where you want to name the cells, selecting the cells using the mouse.
Creating named ranges lets you refer to entire blocks of cells with a single term, saving you lots of time and effort.
When you write a formula, be sure you use absolute referencing ($A$1) if you want the formula to remain the same when it’s copied from one cell to another, or relative referencing (A1) if you want the formula to change to reflect its new position in the worksheet.
Rather than type in a formula from scratch, you can use the Insert Function dialog box to help you on your way.
You can monitor how the value in a cell changes by adding a watch to the watch ...
Get Microsoft® Office System Step by Step -- 2003 Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
