Question 5 • Computer Applications I-Sem A -CA- 39901A
An absolute reference keeps a cell reference fixed when a formula is copied or moved. In an external link, use an absolute reference so the cell reference does not shift; the workbook name identifies the source file but does not lock the cell reference. The correct choice is absolute reference.
AI-written and checked against the verified answer.