Skip to Content
Special Edition Using® Microsoft® Office 2003
book

Special Edition Using® Microsoft® Office 2003

by Ed Bott, Woody Leonhard
September 2003
Beginner to intermediate content levelBeginner to intermediate
1368 pages
56h 14m
English
Que
Content preview from Special Edition Using® Microsoft® Office 2003
726
Chapter 26 Using Formulas and Functions
Using Range Names and Labels in Formulas
Understanding the logic of a complex formula can be a challenge, even when you entered
the formula yourself. This form of amnesia is especially common when you haven’t opened a
particular workbook in months or years.
To make it easier for you to understand a formula’s purpose just by looking at it, you can
enter cell references by using named ranges. This technique is especially useful with cells that
contain constant values such as interest rates, loan amounts, sales tax rates, and discount for-
mulas, because you can define a handful of input cells and then plug the ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Special Edition Using Microsoft® Office XP

Special Edition Using Microsoft® Office XP

Ed Bott, Woody Leonhard
Special Edition Using Microsoft® PowerPoint® 2002

Special Edition Using Microsoft® PowerPoint® 2002

Patrice-Anne Rutledge, Tom Mucciolo

Publisher Resources

ISBN: 0789729555Purchase Link