2. Try
This, Too: Create a Relative Reference All good
equations begin with "equals." Select
Cell C6 and type: = Click on
Cell B1. Type:
ENTER on the keyboard. What Do
You See? The formula in Cell C6 says that C6 equals B1. If you
change the number in Cell B1, it should automatically update in Cell
C6.
Test Your Formula: Change the Data
Select Cell B1 and type: 4.75
Type: ENTER on the keyboard.
Select Cell B1 and type: 3.25
Type: ENTER on the keyboard.
What Else Do You See? The number in Cell C6
should update as soon as you hit the ENTER key.
The other Cells in Column C will NOT update at this
time: those Cells do not have a formula, yet.
Keep going...
Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.3. Apply cell references in
formulas: Relative Cell References
|
|
| |
