When editing a cell address pressing what cause excel to insert dollar symbols in front of the row and column number immediately to the left of the insertion point?

In Excel, pressing the F4 key while editing a cell address will insert dollar symbols in front of the row and column number immediately to the left of the insertion point. This action toggles the reference type between relative, absolute, and mixed references, allowing you to control how the reference behaves when copied to other cells.