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

Cell address will change when it is copied to another cell
An absolute cell address is created
The status bar does not display the cell address
The sheet tab is changed

ANSWER DOWNLOAD EXAMIANS APP