Blog Desk       May 8, 2020      289

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 is 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