6.Absolute reference
Learn what an absolute reference is and how to use it in Excel. This video will cover the basics of absolute references, including how to create them and how they work when you copy and fill formulas. You will also learn how to use absolute references to create complex formulas and to troubleshoot problems with your formulas.