1. Day 3:MICROSOFT EXCEL – CHAPTER 2 Madhuri Siddula masiddula@mix.wvu.edu August 28, 2014

2. Formula basics

3. Cell references • Relative • Absolute • Mixed

4. data

5. Relative reference • Amount financed = House Cost – Down Payment

7. absolute reference • Rate Per Period = Mortgage Rate / Pmts Per Year

8. Make B5 constant throughout column F

9. B5 can be made constant by: • Enter symbol “$” before and after B • Go to the formula and take cursor to B5 and press F4

10. mixed reference • # of payment periods = Years * Pmts Per Year

11. Circular reference Correct the formula: % financed = Amount Financed / House Cost

12. Thank you