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

April 15, 2024 by rawan239

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.