5
AssignmentMultiple Choice

Working with Multiple Worksheets and Workbooks

Question 5 • Computer Applications I-Sem A -CA- 39901A

What must be included in an external link to make sure the cell formula does not change?

Answer
A
internal link
B
workbook name
C
relative reference
D
absolute reference

Explanation

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.