If you have ever used Excel formulas, you probably know how to use the dollar sign ($) to create fixed or absolute references. For example, if you want to refer to cell A1 in a formula and prevent it from changing when you copy or fill the formula to other…