Answer :
Final answer:
To maintain the consistency of a cell formula in an external link, it should include an absolute reference and the name of the workbook.
Explanation:
In an external link, to ensure the cell formula does not change, an absolute reference should be included. Unlike a relative reference, an absolute reference in a formula will remain constant, even when the formula is copied and pasted elsewhere in the workbook. For instance, $A$1 is an example of an absolute reference.
Furthermore, the workbook name should also be included in the external link for effective referencing. Combining both, an external link with an absolute reference to a cell in another workbook might look something like this: '[WorkbookName]WorksheetName'!$A$1.
Learn more about External Link in Excel here:
https://brainly.com/question/16681046
#SPJ1
