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

The correct answer is: A. An absolute cell address is created.

When dollar signs ($) are entered in a cell address, it creates an absolute cell address. An absolute cell address is a cell reference that does not change when it is copied or moved. In the example given, $B$2:$B$10 is an absolute cell address because the column letter (B) and row number (2-10) are both preceded by dollar signs.

Option B is incorrect because an absolute cell address will not change when it is copied to another cell. Option C is incorrect because the sheet tab is not affected by the use of dollar signs in a cell address. Option D is incorrect because the status bar will always display the cell address, regardless of whether or not dollar signs are used.