What type of references should formulas use so that they adjust when copied or filled?

What type of references should formulas use so that they adjust when copied or filled?

• A. Relative
• B. Absolute
• C. Mixed
• D. External

Answer: (A)

When you want a formula to adjust as you copy it to other cells, use relative references. Relative references shift based on where you paste the formula. For example, if a cell contains =A1 and you copy it one cell to the right, it becomes =B1; if you copy it one row down, it becomes =A2. This automatic adjustment makes filling a formula across a range fast and accurate. Absolute references fix parts of the reference with dollar signs (like $A$1), so they do not change when copied. Mixed references lock either the column or the row (like $A1 or A$1). External references point to data in another workbook, which is a different concept. The behavior described in the question aligns with relative references.

When you want a formula to adjust as you copy it to other cells, use relative references. Relative references shift based on where you paste the formula. For example, if a cell contains =A1 and you copy it one cell to the right, it becomes =B1; if you copy it one row down, it becomes =A2. This automatic adjustment makes filling a formula across a range fast and accurate.

Absolute references fix parts of the reference with dollar signs (like $A$1), so they do not change when copied. Mixed references lock either the column or the row (like $A1 or A$1). External references point to data in another workbook, which is a different concept. The behavior described in the question aligns with relative references.