Which statement is true regarding the purpose of using absolute cell referencing in your spreadsheet?
a) An absolute cell reference contains a dollar sign ($) in the row or column coordinates.
b) An absolute cell reference automatically updates when the referenced cell is moved.
c) An absolute cell reference allows the cell to change based on the content of other cells.
d) An absolute cell reference is not affected by changes to other cells' content.
