In Ms Excel, what happens when dollar sign($) are entered in a cell address (ex:$B$2:$B$10)
- The status bar does not display the cell address
- an absolute cell address is created
- cell address will change when it is copied to another cell
- the sheet tab is changed
