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 in created
- Cell address will change when it is copied to another cell
- The sheet tab is changed