The symbol of '$' is used in Microsoft Excel for---
A
fixing the cell
B
copying the cell
C
aligning the cell
D
dragging the cell
Correct Answer: fixing the cell
The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.