You can
double click any Cell that has a formula and see an outline of the
Cell (s) that are used in that equation. Let's
audit this spreadsheet. 4. Try
This: Audit a Relative Reference Double
Click Cell C6. You should see the formula displayed in the
Formula Bar at the top of the spreadsheet. Cell B1 is outlined in
Blue. Double
Click Cell C10. Cell B5 is outlined. What Does
That Mean? The formula in Cell C6 was =B1. Instead of copying $3.25, the
formula (=B1) was AutoFilled.
What Else Do You See? When the formula in Cell
C6 was AutoFilled, the Cell Reference was updated for each Row.
This is an example of a Relative Cell Reference.
It is Relative because it was updated for each Row. Keep
going...
Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.3. Apply cell references in
formulas: Relative Cell References
|
|
| |
