Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.1 Apply Cell Ranges and References In Formulas and Functions:  Use References (Relative, Mixed, Absolute) Create a Relative Reference 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...