In MS Excel what happen when dollar sign are entered in a cell address $A$1:$A&10.

In MS Excel what happen when dollar sign are entered in a cell address $A$1:$A&10.

• A. The status bar doesn't display the cell address
• B. An absolute cell address is created
• C. Cell address will change when it is copied to another cell
• D. The sheet tab is changed

Answer: Option B

Visit the comment section and mention your text our team will be in touch with you in time. (alert-success)

Discuss Related Question