Summary
In this chapter, we have learned about the referencing framework in Excel.
We have learned about the three types of referencing, relative, absolute, and mixed referencing, and when to use each of them.
We have understood that these concepts can save us a lot of time in our Excel work, but it is only relevant when we need to copy a cell or range of cells that contain one or more cell references to another location.
We have learned about the F4 shortcut key and how it toggles between the different forms of referencing.
In the next chapter, we will cover the need to understand the purpose of the assignment and how to build assumptions that are necessary to project our actual results for the next 3 to 5 years.