Q89
What happens when dollar signs ( ) are entered in a cell address? (e B 2: B 10)
A.
An absolute cell address is created
AnswerB.
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
Answer: Option A
Solution:
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.