ExamCompetition Your Success, Our Mission
Login Register
Question discussion

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

283272Medium 1 reply 576 views
41
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  • AAn absolute cell address is created
  • BCell address will change when it is copied to another cell
  • CThe sheet tab is changed
  • DThe status bar does not display the cell address
Correct answer: A
Join the discussion Report an error

Discussion 1

0
CCommunity
An absolute cell address is created

The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.