Blog Desk       February 9, 2021      133

In MS Excel, what happens when dollar sign ($) are entered in a cell address? (ex:$B$2:$B$10)

  1. The status bar does not display the cell address
  2. An absolute cell address in created
  3. Cell address will change when it is copied to another cell
  4. The sheet tab is changed

The Right Answer is : Option B

Explanation