Question 1 • {CR} Computer Applications II
An absolute cell reference keeps both the column and row fixed when a formula is copied. Dollar signs before the column letter and row number mark them as fixed, so $B$5 is an absolute cell reference. D2 is a relative reference because it has no dollar signs.
AI-written and checked against the verified answer.