Question

If a formula is copied and then pasted as a link to another location, what will be true of the new linked data?

a.It will reference different cells from the original formula.
b.It will be invisible if the document is printed.
c.it will be updated if the original cell is updated.
d.It will be easier to share with other people.

Answer 1

c.it will be updated if the original cell is updated.

Step-by-step explanation:

Microsoft Excel is a software application or program designed and developed by Microsoft Inc., for analyzing and visualizing spreadsheet documents.

A spreadsheet can be defined as a file or document which comprises of cells in a tabulated format (rows and columns) typically used for formatting, arranging, analyzing, storing, calculating and sorting data on computer systems.

In Microsoft Excel, if a formula is copied and then pasted as a link to another location (hyperlink), the new linked data (formula) will be updated if the original cell is updated.

This ultimately implies that, a link to an original (main) formula copied to another location would be updated automatically once the main formula is updated or modified.