Exploring Microsoft Excel 2003 Comprehensive
For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.
Results 1-3 of 23
The distinction between cell references that remain constant versus cell
references that change is made by means of a dollar sign. An absolute reference
remains constant throughout the copy operation and is specified with a dollar
sign in ...
(d) Example 4 (dependent cells) Cell reference adjusts to follow moved entry
Moved formula is unchanged (e) Example 5 (absolute cell addresses) Cell
reference adjusts to follow moved entry Both cell references adjust to follow
You must, however, remember the distinction between a relative and an absolute
reference — that is, a cell reference that changes during a copy operation (
relative) versus one that does not (absolute). Consider the PMT function as it
What people are saying - Write a review
What Is a Spreadsheet?
The File Menu
A Better Grade Book
16 other sections not shown