Q. 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) ---
• (D) ---