CampusFin

In Microsoft Excel, which type of cell reference does not change when copied?

Review the verified answer and explanation for this Departmental Recruitment Board of the Prime Minister’s Office (DRB) past-paper question on CampusFin.

In Microsoft Excel, which type of cell reference does not change when copied? Answer: Absolute Reference (e.g., $A$1)

In Microsoft Excel, an Absolute Reference keeps the cell address fixed when a formula is copied to another location. It is represented by the $ symbol, such as $A$1, which locks both the column and row reference. This is useful when using a constant value or fixed cell in multiple formulas.

Question context

This question is part of 📁 Microsoft Office within the broader 💾 Computer Science subject and appears in the Departmental Recruitment Board of the Prime Minister’s Office (DRB) preparation collection. Reviewing the answer together with nearby questions helps reinforce the underlying concept and identify how it may appear in competitive exams.