Discussion :: MS Excel
- 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
Explanation :
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.
Be The First To Comment