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

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

ANSWER DOWNLOAD EXAMIANS APP