What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)

A. An absolute cell address is created

B. Cell address will change when it is copied to another cell

C. The sheet tab is changed

D. The status bar does not display the cell address

Answer: Option A

Solution(By Examveda Team)

The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.

Join The Discussion

Related Questions on MS Excel