_ 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