Blog Desk       January 11, 2025      10

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