Question

To link data other than a chart, you use the Select button and the Copy Link command to create a link between the source file and the destination file.

a. true
b. false

Answer 1

To link data other than a chart, you don't use the Select button and the Copy Link command. Instead, you can use the Paste Link command to create a link between the source file and the destination file.

Step-by-step explanation:

To link data other than a chart, you don't use the Select button and the Copy Link command. Instead, you can use the Paste Link command to create a link between the source file and the destination file.

For example, let's say you have two Excel files, one called 'SourceFile.xlsx' and another called 'DestinationFile.xlsx'. To link a cell value from 'SourceFile.xlsx' to 'DestinationFile.xlsx', you can select the cell in 'DestinationFile.xlsx' where you want the linked value to appear, go to the Home tab, click on the Paste dropdown arrow, and choose Paste Link.

This will create a formula in 'DestinationFile.xlsx' that references the cell in 'SourceFile.xlsx', allowing any changes made in 'SourceFile.xlsx' to automatically update in 'DestinationFile.xlsx'.